| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count from another sheet
My data looks like this:
A Last name B First Name C Year D Academy I've been trying to count people where year = 2007 and Academy = Arts. (And also different years and different academies.) I want my counts to be on Sheet 2. When I used =sumproduct an Update Values: Sort window pops up. Can someone please point me in the right direction? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a daily count sheet with a monthly total | Charts and Charting in Excel | |||
| Should I use COUNT IF? from one sheet to another | Excel Worksheet Functions | |||
| How do i set up a sheet to count the years to retirement? | Excel Worksheet Functions | |||
| I want to count *'s that i have put in my sheet ? | Excel Worksheet Functions | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
