LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Kind of advanced formula question?

In my worksheet I have the name of a paitent, the date they were ENROLLED in
our program, the date they were DISENROLLED from our program and the person
who signed them up.

My boss is only concerned with seeing numbers for them if they were enrolled
for less than 60 days.

I've gotten help for totalling the # of enrolled people per person that
signed them up, but what I actually need to do is only count them if they've
been in the program <60 days, i.e.

Client Name: Signup Date: Quit Date: Counselor
Janet 10-24-07 10-27-07 Mike
Bill 10-24-07 02-15-08 Mike
Evan 10-26-07 11-01-07 Steve
Lucy 10-27-07 06-05-10 Alice

In this example I'd need to see that Mike has ONE "quitter" and Steve has
one as well. So is it possible to make a formula that basically says:

If Col C - Col B = <60 THEN Mike += 1

or something?

Thanks for looking!
 
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
A kind of auto-filter question... [email protected] Excel Worksheet Functions 0 May 3rd 06 08:35 PM
sumproduct question - kind of... Poody Excel Worksheet Functions 3 April 14th 06 08:48 PM
Advanced formula/inserting text question Chas Excel Worksheet Functions 5 March 15th 06 06:13 AM
Pivot Table Question - KIND of UrgentTh [email protected] Excel Discussion (Misc queries) 1 February 15th 06 09:05 PM
Help what kind of formula? Emil0 New Users to Excel 3 February 6th 06 09:10 PM


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