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
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Dec 3, 2010 at 12:44 PM
Related:
- Adding names from two cells
- My contacts list names - Guide
- Ideogram ai names - Guide
- Monk names - Guide
- Best friend contact names with emojis - Guide
- Whatsapp types names - Guide
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 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