I searched through the threads related to countif with multiple criteria to find my answer and came up empty. Is it possible to have the selection be an entire column, A:A and K:K, in this example? Rather than a defined column/row range?
=SUMPRODUCT(--('2005'!A$2:A$2344="January"),--('2005'!K$2:K$2344<575))
When I choose the entire column the result is #NUM!. This formula works for my previous years data sheet, 2005, because no more data is added to it.
However, 2006 will have data added to it on a daily basis and I don't want to have to change the selection each time to get the accurate results.
Thanks in advance!