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)
NB.SI(OIL!K4:ZZ300;KPI!F1)
and the COUNTIFS that is try to use is as follows
NB.SI.ENS(OIL!2:2;KPI!A2;OIL!K4:ZZ300;KPI!F1)
When i try this function i get #VALUE error ... could you please help me with this error ?
Ps. :
- NB.SI is the french translation of COUNTIF
- NB.SI.ENS is the french translation of COUNTIFS
- I'm using french EXCEL
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:
COUNTIFS requires all criteria ranges to be the same size and dimension. So, you can't use both the entire row 2 and K4:ZZ300 as criteria ranges.
glennmckenna No you may not.
