Excel Formula
Closed
Ashsih02
-
Jun 12, 2009 at 07:52 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Jun 13, 2009 at 04:16 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Jun 13, 2009 at 04:16 AM
Related:
- Excel Formula
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Excel color formula - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2025
491
Jun 13, 2009 at 04:16 AM
Jun 13, 2009 at 04:16 AM
Hi,
Try with this formula :
Case 1 :
= SUMPRODUCT((A1:A14="aminul")*(B1:B14="ok"))
Case 2 :
= SUMPRODUCT((A1:A14="aminul")*(B1:B14="Not ok"))
Case 3 :
= SUMPRODUCT((A1:A14="ratna")*(B1:B14="ok"))
Case 4 :
= SUMPRODUCT((A1:A14="ratna")*(B1:B14="Not ok"))
Best regards
Try with this formula :
Case 1 :
= SUMPRODUCT((A1:A14="aminul")*(B1:B14="ok"))
Case 2 :
= SUMPRODUCT((A1:A14="aminul")*(B1:B14="Not ok"))
Case 3 :
= SUMPRODUCT((A1:A14="ratna")*(B1:B14="ok"))
Case 4 :
= SUMPRODUCT((A1:A14="ratna")*(B1:B14="Not ok"))
Best regards
