View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin Fishlock Martin Fishlock is offline
external usenet poster
 
Posts: 694
Default 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!