Help needed using the serial number date with sumifs - whole office is stumped

[FraserKitchell]

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