Adding names from two cells Closed

Question

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!

aquarelle · Answer

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

Adding names from two cells

1 response

Similar discussions

Subscribe To Our Newsletter!