Would anyone have any idea why this formula works:
Formula:
Please Login or Register to view this content.
But when I try to add another criteria, it returns 0?
Formula:Please Login or Register to view this content.
The raw data is there, and it should be returning some numbers. I am unable to attach the spreadsheet. Work use only.
Last edited by sinspawn56; 01-07-2013 at 03:16 PM.
If the new criterion only has to match a single value just do a straight comparison, i.e.
=SUMPRODUCT(ISNUMBER(MATCH(raw!$F$1:$F$5000,$H$6:$H$7,0))*ISNUMBER(MATCH(raw!$H$1:$H$5000,$L$20:$L$44,0))*(raw!$A$1:$A$5000=A24))
Audere est facere
In my attempt to get it working, I had tried that. You however validated that it was indeed possible to do it. So I started looking at the raw data, and it was a formatting issue. I guess it just takes a second mind. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks