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

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

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

You're welcome.

Pete

On Jan 12, 2:37*am, JMK wrote:
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!!!!!- Hide quoted text -

- Show quoted text -