Cell Reference Question
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 -
|