Excel Formula [Closed]

Report
-
Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
-
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

Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
475
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!