Forum Discussion
Solved
Join 2 COUNTIF to become 1 COUNTIFS
Hello, I've got 2 COUNTIF function that work fine how ever i would like to combine them to become 1 COUNTIFS The 2 COUNTIF work fine by themselves and are as follow : NB.SI(OIL!2:2;KPI!A2)
...
Can you give an example of what you would want to be returned?
For instance, would you ask how many '456' exist in columns for 21-dec-2023? The answer would be 2.
Would there really by duplicate dates in row 1?
Which Excel version are you using?
Perhaps something like this:
glennmckenna No you may not.