Forum Discussion
Join 2 COUNTIF to become 1 COUNTIFS
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:
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 :
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:
- I'm using O365 enterprise
In the example i used dates but in reality it will be week numbers therefor there might be duplicates
what i'm looking for is indeed how many "456" exist in a column, for example for column 22/12/2023 i want excel to tell me that there is 3 instances of "456"glennmckenna I added a screenshot to my previous post, perhaps just after you read it. It that what you wanted?
- That was indeed the case, iv'e got it to work in the example that we've shared it looks like it's what i'm after
however when i try it in the real excel i get #N/A
here is the function
=SOMME((OIL!3:3=KPI!A2)*(OIL!K4:ZZ300=KPI!F$1))