SUMIFS and Dates

D

d

=SUMIFS(Detail!C:C,Detail!A:A,">=B6",Detail!A:A,"<=C6",Detail!B:B,"Installation")

Detail Sheet
Date Type Qty
2/8/2010 Sales 2.00
2/8/2010 Credits 1.00
2/10/2010 Sales 1.00
2/12/2010 Credits 3.50
2/12/2010 Sales 1.00

I am trying to summarize
Week No. Start End Sales
1 2/1/2010 2/5/2010 0
2 2/8/2010 2/12/2010 0
3 2/15/2010 2/19/2010 0

But this seems to be ignoring my date test. Is there something I am
missing? (Note - when I test for other types of things (not dates as a test)
it works)
 
D

Dave Peterson

">=B6"
is actually looking at the text B6--not what's in the cell B6:

=SUMIFS(Detail!C:C,
Detail!A:A,">="&B6,
Detail!A:A,"<="&C6,
Detail!B:B,"Installation")
 

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

Top