=sumproduct(--(A1:A65536=1),--(C1:C655360))

"Shawn" wrote:

I need an array formula that will do the following. Count (not sum) the
number of cells in column C that are above the value of 0 if the adjacent
cells in Column A are equal to a value of 1.



--
Thanks
Shawn