Hello
I'm trying to get the result of multiplying numbers from column B by numbers in column E with criteria from column F where criteria is "competitive"
I used sumproduct formula as below however in return I get value error - in cell H1
can you please advise where is the problem or what other formula I might use?
Capture.PNG
attached also file
Thanks
Please try with Ctrl+Shitf+Enter
=SUM((F3:F577="competitive")*IFERROR(B3:B577*E3:E577,0))
Hi Bo_Ry
it worked
thanks
However I'm wondering if there is any solution with sumproduct to use later other criteria?
thanks
You can use sumproduct but still need CSE becase of iferror, then better use just Sum
=sumproduct((F3:F577="competitive")*IFERROR(B3:B577*E3:E577,0))
I think this is a FIRST for me.... I might be about to improve on one of Bo_Ry's replies.... Sound of trumpets playing in the sky...
You can use SUMPRODUCT, in a non-array formula, like this:
=SUMPRODUCT(--(F3:F577="competitive"),B3:B577,E3:E577)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glenn, I did B5*E5 and got #VALUE! So I though we need iferror, but I was wrong.
Len(E5) = 0 if I hit Enter at E5, #VALUE! is gone and B5*E5 = 0
Do you know what's in E5?
I dimly remember seeing something like this before.... but I can't remember what caused it... A HEX character???
Thanks, Glenn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks