Adding names from two cells [Closed]

Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
Hello,


Column 1 Column2
Apple Seed
Apple Tree
Peach Seed
Peach Seed
Peach Tree
Apple Seed
Peach Seed
Apple Seed
Apple Tree
Apple Tree

Totals:
Apple Tree < need forumla to calculate
Apple Seed < need forumla to calculate
Peach Tree < need forumla to calculate
Peach Seed < need forumla to calculate


Thanks!

1 reply

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
484
Hi,

Try these formula :

1)=SUMPRODUCT((A2:A11="Apple")*(B2:B11="Tree"))
2)=SUMPRODUCT((A2:A11="Apple")*(B2:B11="Seed"))
3)=SUMPRODUCT((A2:A11="Peach")*(B2:B11="Tree"))
4)=SUMPRODUCT((A2:A11="Peach")*(B2:B11="Seed"))

Best regards

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!