Sumproduct or Countif
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!
|