Previous Topic Next Topic

Adding names from two cells

Closed
Samantha - Dec 2, 2010 at 09:15 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Dec 3, 2010 at 12:44 PM
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!
Related:

1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Dec 3, 2010 at 12:44 PM
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
0

Similar discussions

Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Can you rename the inputs on LG Smart TV (WebOS)?
sjdunning -
dhh1 -

4 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response