Adding names from two cells
Closed
Samantha
-
2 Dec 2010 à 09:15
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 3 Dec 2010 à 12:44
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 3 Dec 2010 à 12:44
Related:
- Adding names from two cells
- Monk names wow - Guide
- Count names in excel - Guide
- Error 5 getting session names - Guide
- Funny ikea names - Home - Apps & Sites
- Lg tv edit input names ✓ - Smart TV Forum
1 response
aquarelle
Posts
7181
Registration date
Saturday 7 April 2007
Status
Moderator
Last seen
14 February 2026
491
3 Dec 2010 à 12:44
3 Dec 2010 à 12:44
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
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
