#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeremy Ellison
 
Posts: n/a
Default Sumproduct

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Sumproduct

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)))


--

Regards,

Peo Sjoblom

"Jeremy Ellison" wrote in message
...
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<=DA TE(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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct Peter B Excel Worksheet Functions 1 March 7th 05 02:59 PM
sumproduct causing memory errors? dave Excel Worksheet Functions 1 March 3rd 05 10:31 AM
Can I reference =, <, or > sign in SUMPRODUCT BobT Excel Discussion (Misc queries) 7 February 16th 05 02:58 PM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 06:15 AM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 10:08 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"