Excel Formula [Closed]

Question

Excel Formula [Closed]

Report

Ashsih02 - Jun 12, 2009 at 07:52 AM
aquarelle

Posts: 7083
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

- 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

Excel Formula
Excel formula bar missing - How-To - Excel
Excel formula @ symbol ✓ - Forum - Excel
Excel formula to clear cell contents - How-To - Excel
Excel formula for position ✓ - Forum - Office Software
Maximum number of if statements in excel formula - How-To - Excel

1 reply

Ask a question

aquarelle · Accepted Answer · 2009-06-13T04:16:47-0400

Answer 1 / 1

aquarelle

Posts: 7083
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: September 25, 2020

475
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

Excel Formula [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!