Sumproduct

G

Guest

Why does this not work:

=SUMPRODUCT(--(CaseData!$X$2:$X$1000="Yes")*--(CaseData!$C$2:$C$1000>=--DATE(2006,1,1)*--(CaseData!$C$2:$C$1000<=--DATE(2006,3,31))))


and this does:

=SUMPRODUCT((ISNUMBER(SEARCH("Yes",CaseData!$X$2:$X$2000)))*(CaseData!$C$2:$C$2000>=DATE(2006,1,1))*(CaseData!$C$2:$C$2000<=DATE(2006,3,31)))

I am trying to get the total number of Yes' in column X if the date is
between 1/1/6 and 3/31/6.
 
P

Peo Sjoblom

This works

=SUMPRODUCT(--(CaseData!$X$2:$X$1000="Yes"),--(CaseData!$C$2:$C$1000>=DATE(2
006,1,1)),--(CaseData!$C$2:$C$1000<=DATE(2006,3,31)))
 

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

SUMPRODUCT Question.... 5
value of #'s in column if between dates 8
Unique numbers if between dates 3
Scrabble Value calculation for Welsh words 0
Sumproduct Help! 2
Excel Help with dates 2
sumproduct with varying column ranges 1
Sumproduct 1

Top