Bob,

Thank you for your response. I was attempting to use a range of $A2:$A9999
(which would include blanks) in order to capture new information as it was
entered. Do array formulas update automatically? Is there a way to alter
the formula to handle blanks in column A?

Thanks!

"Bob Phillips" wrote:

=SUM(--(FREQUENCY(IF($C$1:$C$10<"",MATCH($A$1:$A$10,$A$1 :$A$10,0)),ROW(INDI
RECT("1:"&ROWS($A$1:$A$10))))0))

and

=SUM(--(FREQUENCY(IF($C$1:$C$10="",MATCH($A$1:$A$10,$A$1: $A$10,0)),ROW(INDIR
ECT("1:"&ROWS($A$1:$A$10))))0))

which arearray formulae, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Note the second will fail if you have blanks in column A

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"mhmra" wrote in message
...
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!