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.

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.

Count from another sheet
 

something like:

=SUMPRODUCT(--(Sheet1!C1:C100=2007)*--(Sheet1!D1:D100="ARTS"))

--
Gary''s Student - gsnu200721

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.