Adding names from two cells
Closed
Samantha
-
Dec 2, 2010 at 09:15 AM
aquarelle Posts 7180 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Dec 3, 2010 at 12:44 PM
aquarelle Posts 7180 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Dec 3, 2010 at 12:44 PM
Related:
- Adding names from two cells
- Ideogram ai names - Guide
- My contacts list names - Guide
- Wow monk names - Guide
- Count names in excel - Guide
- Based on the values in cells b77 ✓ - Excel Forum
1 response
aquarelle
Posts
7180
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Dec 3, 2010 at 12:44 PM
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
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