In the example file, I'm trying to come up with a formula that will allow me to count the number of cells in Columns AR:BD that match the value in Column AN, AND that have a value in Column AO. In the attached example, I've tried to use COUNTIFS
"functionality" but I can't seem to find a way to use that because not all Criteria Ranges have the same number of Columns (which is required by the COUNTIFS
function. Can someone suggest how I can get around this, perhaps with a different combination of functions?
Thanks for any insights!