View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seb Seb is offline
external usenet poster
 
Posts: 6
Default COUNTIF using conditions

I have a spreadsheet with multiple column.

For example :

Satus Id
Delivered 12
Not delivered 13
Delivered --
Delivered 14

I would to count the number of non-blank cells in the column "Id" depending
on the Status. The goal is to get the number of non-blank cells for Delivered
status and get the number of non-blank cells for Not Delivered status,

In general view I have to count the number of non-blank cells in column Id
depending on the value of the column "status"