I would like to count the number of times a letter is present in an array based on multiple criteria. I seem to have been unable to do this so far because the arrays are different sizes perhaps.
In the attached example workbook the blank cells in the array D13:DT972 contain the text "" .
Any suggestions would be appreciated.
Yes, it's because the ranges are of different dimensions.
COUNTIFS (and all the xxIFs functions) require all ranges to be of the same dimensions
Try this in D5
=SUMPRODUCT(($B$13:$B$972=$B5)*($C$13:$C$972=$C5)*($D$12:$DT$12>$C$2)*($D$13:$DT$972=D$4))
Your ranges in COUNTIFS have to match, you cant have that range across the top, along with all the other ranges going downwards.
I am out of time right now, but will take a look again soon
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
Jonmo1 - Thank you very much, your formula does exactly what I need it to.
FDibbins - Thanks for offering to take a look, the SUMPRODUCT formula counts the text based on the criteria as hoped so no further action required.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks