LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tricia S.
 
Posts: n/a
Default counting cells (COUNTIF) based on two or more criteria

Iam using Excel 2003 and I am trying to count a row based on two criteria.
For example: I am trying to count all those rows where cell B has a value of
"1" AND cell F has a value of "Completed".
The COUNTIF() function appears to only accept one group of parameters.
Using the COUNTIF() function twice in the cell with the + operator between
them appears to add those that qualify for each criteria and the "&" appears
to be giving me results I have yet to figure out.

I am trying to build a summary table like below based on a worksheet with
many detail records (rows) in another worksheet in the same workbook:
Status Level 1 Level 2 Level 3 .... Level 10
Open 10 13 1 24
Started 9 7 3 18
Completed 5 9 12 11
Etc

 
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
Adding colour to a range of cells based on one of the cells v... McKenna Excel Discussion (Misc queries) 4 March 11th 05 02:25 PM
counting cells with conditional formatting applied HalB Excel Discussion (Misc queries) 3 February 21st 05 01:21 PM
Counting an Array based on a calculation HokieLawrence Excel Discussion (Misc queries) 10 February 16th 05 02:39 AM
CountIF cells are not empty Wayne Excel Discussion (Misc queries) 3 January 6th 05 04:44 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 2nd 04 11:04 PM


All times are GMT +1. The time now is 05:12 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"