Try these array formulas:

=COUNT( 1 / ( MATCH( $A$1:$A$10, IF( ( $A$1:$A$10 < "" ) * ( $C$1:$C$10 <
"" ), $A$1:$A$10, #N/A ), 0 ) = ( ROW( $A$1:$A$10 ) - ROW( $A$1 ) + 1 ) ) )

and

=COUNT( 1 / ( MATCH( $A$1:$A$10, IF( ( $A$1:$A$10 < "" ) * ( $C$1:$C$10 =
"" ), $A$1:$A$10, #N/A ), 0 ) = ( ROW( $A$1:$A$10 ) - ROW( $A$1 ) + 1 ) ) )

--
Regards,
Luc.

"Festina Lente"


"mhmra" wrote:

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

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

Thanks!