I was trying to figure out what he meant by "Ignoring". But I guess he meant to include corresponding values that have blank cells; here is another take, it may be slower than cutter tho:
EDIT: Removed the "--", I don't think they're needed.
=SUMPRODUCT(((B4:B19=I3)+(B4:B19="")),((C4:C19=I4)+(C4:C19="")),((D4:D19=I5)+(D4:D19="")),E4:E19)
Last edited by ron2k_1; 04-17-2012 at 02:25 PM.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
coreyjo 
Register To Reply
Bookmarks