#### Anne Troy

##### MrExcel MVP

- Joined
- Feb 18, 2002

- Messages
- 2,632

- Office Version
- 365

- Platform
- Windows

the next row down contains the number of people in each group.

so:

Group l ABAE 501 l ABAE 502 l ABAE 503 l

size l 12 l 15 l 10 l

Eng. 111 l 9/12/02 l 9/24/02 l 9/16/02 l

Bus 240 l 10/10/02 l 11/28/02 l 10/21/02 l

MIS 310 l 11/14/02 l 01/05/02 l 12/02/02 l

there are 12 rows and 16 columns.

on another worksheet, I have a list of classes. I have the formula

Eng111 l{=SUM(IF(BookDelDate!$A3:$AA3>=Begdate,IF(BookDelDate!$A3:$AA3<=Enddate,students,0),0))} (students is the named range A1 to AA1)

Bus 240 l (formula with row 4)

MIS 310 l formula with row 5)

and on down

The data in the table consists of dates that show when a group will take a class. This formula accurately shows how many students will take a class within a date range. Begdate is cell D1 on the worksheet with the list of classes, Enddate is D2. A user can put in any beginning and any ending date and see how many students will take that class within the dates

I need something similar that will tell me which group they belong to! hope htis is clear enough.

_________________

Anne@MrExcel.com

This message was edited by Dreamboat on 2002-09-11 19:43