Cell Reference Question

[JMK]

Good Evening Everyone,

Im sure this is simple, but Im having a bit of a brain cramp.

=SUMIF(Logbook!$A$6:$A$1400,"="A4,Logbook!G$6:R$1400)

This is placed in the E column, based on the headings below

Date Start Stop Total Retrieved Time

I need to know if there is a way of getting the "="A4 to auto update with
each new entry in a row (so going from A4 to A5, the formula would adjust
automatically to reflect the new line). Ive tried anchoring the formula, but
its not working.

Please Help!!!!!

 

[Pete_UK]

You don't need the "=", so you could write it as:

=SUMIF(Logbook!$A$6:$A$1400,A4,Logbook!G$6:G$1400)

and if you copy this down you should find the A4 change to A5, A6 etc.

Hope this helps.

Pete

 

[JMK]

Thank you!!!! Big brain fart on my part!!! thanks

 

[Pete_UK]

You're welcome.

Pete

Thank you!!!! Big brain fart on my part!!! thanks






- Show quoted text -