You'll need to use SUMPRODUCT, not COUNT, COUNTIF, or COUNTA for that task.

The COUNT functions work only on one set of criterias, not multiple sets
(same with SUMIF...)

Dave
--
Brevity is the soul of wit.


"M.Moncrief" wrote:

I need to count the number of dates in column Y based on whether or not a
number is entered in column X. I've tried several varieties of the COUNT
functions and keep getting errors.

Here is scenario: if columnX contains "1" in any of the cells, I need the
function to count the number of dates in columnY that correspond to those
cells from columnX with the number 1.

Thanks,
M.Moncrief