Jun 08 2021 01:50 PM
Hi,
I was sure Countifs counted with AND, when all logical test was true. But This one list if one of the conditions is met.
=Countifs(B4:B9;B2;C4:C9;E4:E9)
Any excplanation to that?
Example is attached.
Best Regards
- Geir
Jun 08 2021 01:59 PM
Can you explain in detail what you want to accomplish?
Jun 08 2021 02:04 PM
Jun 08 2021 02:23 PM
SolutionAs you have found, COUNTIFS is not the correct function for this. COUNTIFS(C4:C9,E4:E9) compares every cell in C4:C9 with every cell in E4:E9 instead of C4 with E4, C5 with E5 etc.
Your SUMPRODUCT formula is the one to use.
Jun 08 2021 02:36 PM
Jun 08 2021 02:37 PM
Jun 08 2021 03:45 PM
Jun 09 2021 04:16 AM
Jun 08 2021 02:23 PM
SolutionAs you have found, COUNTIFS is not the correct function for this. COUNTIFS(C4:C9,E4:E9) compares every cell in C4:C9 with every cell in E4:E9 instead of C4 with E4, C5 with E5 etc.
Your SUMPRODUCT formula is the one to use.