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:
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.
Do you have another solution ?
What i'm trying to do is get excel to find the columns where the values match a certain date/value (these values are all on 1 line) and the look in those columns and count the values that match "456"
I've can't use a Pivot table
here is an example of the excel :
