C
CindyK
I am trying to add up amounts if they occurred in any
prior period to the one I'm currently in. So, my formula
is =SUMIF(D52:AH52,<=D86,D58:AH58), where row 52 is a row
of dates that I want to test on, row 58 is the numbers I
want to add up, and D86 is the date of the period I'm
currently in. Simple, huh? Not so!
Excel demands that I enclose my criterion (i.e., D86) in
quotes. But then, as I copy it across it doesn't change.
How do you use SUMIF if the criterion you want to use is
a cell reference, not a specific number or text string?
I've tried using a named range, but that doesn't seem to
work either.
This drives me NUTS! I'd be very grateful for any help.
prior period to the one I'm currently in. So, my formula
is =SUMIF(D52:AH52,<=D86,D58:AH58), where row 52 is a row
of dates that I want to test on, row 58 is the numbers I
want to add up, and D86 is the date of the period I'm
currently in. Simple, huh? Not so!
Excel demands that I enclose my criterion (i.e., D86) in
quotes. But then, as I copy it across it doesn't change.
How do you use SUMIF if the criterion you want to use is
a cell reference, not a specific number or text string?
I've tried using a named range, but that doesn't seem to
work either.
This drives me NUTS! I'd be very grateful for any help.