LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ross
 
Posts: n/a
Default nesting with countif

Hi,
I am having trouble with nesting the and command in a sheet I am
attmepting to prepare a spreadsheet to keep track of the clients in the
various programs at the not-for-profit blind services agency where I work.
I pasted a small piece of the sheet below. I used the countif function in
the formulas in column R below
=COUNTIF($S$25:$S$31,"Alp II", =COUNTIF($S$25:$S$31,"Alp III",
=COUNTIF($S$25:$S$31,"Alp II E", and =COUNTIF($S$25:$S$31,"Ancillary to add
up the how many people were in each program, but I have not been able to
figure out how to count for example Alp IIs, who have been closed. As you
can see at the bottom, I put in an example of one attempt to nest the "AND"
function with the countif, but Ecel said no. So can anyone tell me how to
build a formula that will count not only the total from each program as I
have done, but also the total for each program, whose case has been closed
(note the X under CL means client is closed.

O P Q R
S
Clients CL opened Closed
Program
Blow, Joe X 4/3/05 7/12/05
Alp II
Lincoln, Abraham 6/18/05
Alp III
Wifenpicle, T 7/14/05
Ancillary
Washington, G X 4/19/05 7/23/05 Alp II
E
Wilson, W. 8/8/88
Alp II
Truman, H. S. X 3/24/05 4/12/05
Ancillary

Total Alp II: 2 =COUNTIF($S$25:$S$31,"Alp II", (formula that
works)
Total ALP III: 1
Total Alp II E: 1
Total Ancillary: 2

(below is one of my miserable unsuccessful attempts at making the formula
=COUNTIF($p$25:$p$30,"X"), AND( $s$25:$S$30,"Alp II")




--------------------------------------------------------------------------------





 
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 COMBINATION?? Heather Excel Worksheet Functions 1 April 26th 05 02:44 AM
Combining IF and COUNTIF based on two columns maxtrixx Excel Discussion (Misc queries) 5 March 31st 05 06:21 PM
Nesting formulae with COUNTIF Helen McClaine Excel Discussion (Misc queries) 1 January 22nd 05 12:52 AM
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM


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

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"