View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
enna49 enna49 is offline
external usenet poster
 
Posts: 54
Default Not to inlcude zero in COUNT

Hi
Please can you help with this problem.
I need a count in a column with amounts. The problem being I do require to
count the Credits and Debits, but NOT the 0 (ZEROS). I do have 3 criteria
that this applies to. eg
If Cols B, C and D meet the criteria count any activity in N.
Thanking you
Anne