| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count from another sheet
=SUMPRODUCT(--(Sheet1!C1:C100=2007),--(Sheet1!D1:D100="Arts"))
etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tesons" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count from another sheet
something like:
=SUMPRODUCT(--(Sheet1!C1:C100=2007)*--(Sheet1!D1:D100="ARTS")) -- Gary''s Student - gsnu200721 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count from another sheet
Thank you ... that works!
"Bob Phillips" wrote: =SUMPRODUCT(--(Sheet1!C1:C100=2007),--(Sheet1!D1:D100="Arts")) etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tesons" wrote in message ... 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. |
| Reply |
| 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) | |||
Linear Mode
