Hi All,
I'm trying to do a countifs with a specific criteria
I want to count all the entries of year 2019 and 2018.
Please see attached, I've also placed my initial formula but it does not reflect the correct count
Any help will do. thanks!
Hi All,
I'm trying to do a countifs with a specific criteria
I want to count all the entries of year 2019 and 2018.
Please see attached, I've also placed my initial formula but it does not reflect the correct count
Any help will do. thanks!
You need to extract the year from the column A range which can be achieved by YEAR(range)
But you can't put this in a COUNTIFs so use SUMPRODUCT instead
in F2
=SUMPRODUCT((YEAR($A$2:$A$1000)=F$1)*($B$2:$B$1000=$E2))
and copy across and down the grid
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Another option...
=COUNTIFS($B:$B,$E2,$A:$A,">="&DATE(F$1,1,1),$A:$A,"<="&DATE(F$1,11,31))
copied down and across as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi All, thanks! used FDibbins suggestion
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks