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

"Pete_UK" wrote:

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

On Jan 12, 1:21 am, JMK wrote:
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$14 00)

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!!!!!