Excel Formula

Closed
Ashsih02 - Jun 12, 2009 at 07:52 AM
aquarelle
Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
- Jun 13, 2009 at 04:16 AM
Hello,
I need to calculate between two columns. Such as: If there is written (A2:A100) "aminul", then count how many times was written (B2:B100) "ok".

If there is written (A2:A100) "aminul", then count how many times was written (B2:B100) "Not ok".

If there is written (A2:A100) "ratna", then count how many times was written (B2:B100) "ok".

If there is written (A2:A100) "ratna", then count how many times was written (B2:B100) "not ok".

Thanks

1 reply

aquarelle
Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
490
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
1