Martin,

I've included a data sample below. I need a count of column A by each
unique entry when Column C is populated and a separate count when Column C is
blank.

Data sample:

Column A Column C
5100 11/27/06
5100
5100 11/28/06
2420 11/26/06
2420
2420 11/28/06

How would you conditionally nest your formulae together (countblank and
CountA)?

Thanks!

"Martin Fishlock" wrote:

for counting blanks try countblank(range)
for non-blanks try counta(range) or totalcells -countblank(range)

--
Hope this helps
Martin Fishlock


"mhmra" wrote:

Corrected (sorry)

Inventory spreadhseet with Column A = multiple product models and column c =
Date received

Need formula to count each criteria in column A if column c is blank.
Need second formula if column c is non-blank.

Thanks!