Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to count occurrence?

Under column A, there is a list of Result - "DONE", "WARN", ""
I would like to count the number of occurrence of "DONE" and "WARN" in
column, and return the result in cell B1, such as
Under Column A
DONE
DONE

WARN
DONE

There are 4 occurrences for DONE or WARN, then 4 is return in cell B1 .
Does anyone have any suggestions?
Thank in advance for any suggestions
Eric
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default How to count occurrence?

Try one of these:

=COUNTIF(A:A,"Done")+COUNTIF(A:A,"Warn")

=SUM(COUNTIF(A:A,{"Done","Warn"}))

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
Under column A, there is a list of Result - "DONE", "WARN", ""
I would like to count the number of occurrence of "DONE" and "WARN" in
column, and return the result in cell B1, such as
Under Column A
DONE
DONE

WARN
DONE

There are 4 occurrences for DONE or WARN, then 4 is return in cell B1 .
Does anyone have any suggestions?
Thank in advance for any suggestions
Eric



Reply
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
count occurrence between two specific dates AzMan Excel Discussion (Misc queries) 1 April 25th 07 07:52 PM
Count occurrence of character within a cell Kelli Excel Discussion (Misc queries) 2 January 18th 06 03:20 PM
Match Last Occurrence of Numeric Value and Count BACK to Previous Sam via OfficeKB.com Excel Worksheet Functions 4 November 24th 05 03:15 AM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
occurrence (last) reference excelFan Excel Discussion (Misc queries) 4 March 7th 05 12:51 PM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"