Adding names from two cells [Closed]

Question

Adding names from two cells [Closed]

Report

Samantha - Dec 2, 2010 at 09:15 AM
aquarelle

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

- 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!

Adding names from two cells
Open Office Calc - Adding borders to the cells - How-To - OpenOffice.org
Adding two non-adjacent cells (number and text) ✓ - Forum - Excel
Excel - Adding the current date in cell - How-To - Excel
Adding Cells ✓ - Forum - Excel
Using a named cell in a macro - same workbook ✓ - Forum - Excel

1 reply

Ask a question

aquarelle · Answer 1 · 2010-12-03T12:44:56-0500

Answer 1 / 1

aquarelle

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

484
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

Adding names from two cells [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!