Cell Reference Question

  • Thread starter Thread starter JMK
  • Start date Start date
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with 2 criterias 2
Formula Question 2
Copy a formula using Vlookup 2
Help with a pop-up msg 5
Matrix 1
Conditional Formula 2
Best way to insert rows 5
Copying formula with cell reference decreasing automatically 8

Back
Top