Dear friends,
I have a question on counting a value with the following example.
example.JPG
as shown in the example, i tried to count "good" with "banana" as criteria but it returns error. especially something is wrong in defining range as B2:K4, if i do B2:B4 it works.....I am confused!
Please suggest
many thanks
Prad
Try
=SUMPRODUCT((A2:A4="banana")*(B2:K4="good"))
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.
Thanks Fotis - I have another concern - what if there is either or criteria - lets say =SUMPRODUCT((A2:A4="banana")*(B2:K4="good"))
in B2:K4 = either "good" or "not bad"; how to include this criteria in the formula?
sorry if i asked you something stupid !
Prad
Better stillOriginally Posted by Fotis1991
=SUMPRODUCT((A2:A4="ouzo")*(B2:K4="very good"))
Try this.
=SUMPRODUCT((A2:A4="banana")*(B2:K4="good"))+SUMPRODUCT((A2:A4="banana")*(B2:K4="not bad"))
@ pepe
Better use this one.
=SUMPRODUCT((A2:A4="ouzo")*(B2:K4="very good"))+SUMPRODUCT((A2:A4="raki")*(B2:K4="excellent"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks