=SUMPRODUCT((Drop!B1:B100000="11/12/2012")*(Drop!D1:D100000="Enrique Garcia")*(Drop!F1:F100000="Closed"))
I'm trying to create a formula that will count a row so long as three conditions are met. A specific date, a specific user, and status is "closed". What have I done wrong with this formula?
Try it like this:
=SUMPRODUCT((Drop!B1:B100000=--"11/12/2012")*(Drop!D1:D100000="Enrique Garcia")*(Drop!F1:F100000="Closed"))
It's most likely the date that's the problem, you have it as a string, "11/12/2012", in the formula on the worksheet it's a number.
Try putting 11/12/2012 in a cell and substiting "11/12/2012" for the cell refernce.
For example if you have 11/12/2012 in A1:
=SUMPRODUCT((Drop!B1:B100000=A1)*(Drop!D1:D100000="Enrique Garcia")*(Drop!F1:F100000="Closed"))
If posting code please use code tags, see here.
Have you tried using COUNTIFS?Let me know if this is what you were looking for!
Please Login or Register to view this content.
Simeon
Don't forget to click the star in this post!
My suggestion(as your profile says that you work in Excel 2010) is to use COUNTIFS.
SUMPRODUCT with 100000 !! rows, will kill your computer.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks