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