I ma trying to use sumproduct but am getting the answer zero, rather than the count of number of cells that meet my criteria. I have attached an example of my data. What am I doing wrong ?
Thanks for your thoughts !!
I ma trying to use sumproduct but am getting the answer zero, rather than the count of number of cells that meet my criteria. I have attached an example of my data. What am I doing wrong ?
Thanks for your thoughts !!
2 more paranthesis.
=SUMPRODUCT((Data!C:C=Summary!$C7)*(Data!D:D<Summary!D$6))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
you are missing some parentheses
=SUMPRODUCT((Data!C:C=Summary!$C7)*(Data!D:D<Summary!D$6))
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks chaps !!
See attached:
Gary's Student
also since you appear to be using 2007 or later
=COUNTIFS(Data!$C:$C,$C7,Data!$D:$D,"<"&D$6)
is more efficient
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks