April 2018

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".

Try with this formula :

= SUMPRODUCT((A1:A14="aminul")*(B1:B14="ok"))

= SUMPRODUCT((A1:A14="aminul")*(B1:B14="Not ok"))

= SUMPRODUCT((A1:A14="ratna")*(B1:B14="ok"))

= SUMPRODUCT((A1:A14="ratna")*(B1:B14="Not ok"))

Best regards

Thanks to aquarelle for this tip on the forum.

- Excel – Formula to calculate between two columns
- Add a Specific Number of Days to a Date in Excel » How-To - Excel
- Excel - A formula to count a list of names » How-To - Excel
- Excel formula which calculates start date » Forum - Excel
- Excel formula to compare two columns and return a value (Solved) » Forum - Excel
- Excel formula to compare two columns and return a value » Forum - Excel