Hi all,
I've got a question thats been stumping all of us around the office for a few days now and it seems simple enough but we just can't get at the formula. Basically, I want to create a formula that looks something like this:
=SUMIF($A$12:$A$200,
">=B2", $B$12:$B$200)-SUMIF($A$12:$A$200,
">C2", $B$12:$B$200)
Where
B2 and
C2 are both dates driven off of a cell. The problem is, I cant this darn sumif to understand that these are dates unless I hard type them into the formula for each cell. I have tried changing the formatting of the cells, tried them as text, and as a serial number date, etc, but nothing seems to work. From what I can gather from this forum, I am beginning to wonder if Sumif is even the correct formula or if a sumproduct or something would be better.
I've attached a spreadsheet with some real data in it if you'd like to take a look.
Thanks! My office eagerly awaits the answer
