LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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"

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif with 2 Conditions cmsinsides New Users to Excel 5 December 30th 08 07:35 AM
Countif Conditions - Use of conditions that vary by cell value JonTarg Excel Discussion (Misc queries) 1 May 30th 08 01:21 PM
Using CountIf with 2 conditions - help! Sarah Excel Worksheet Functions 6 May 23rd 06 07:18 PM
Countif with conditions Mosqui Excel Worksheet Functions 2 December 5th 05 04:10 AM
COUNTIF 2 conditions Sojo Excel Worksheet Functions 2 June 29th 05 08:37 PM


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"