You can add the sheet names:

=sumproduct(--(A1:A10="john"),--(B1:B10="sick"))
becomes:
=sumproduct(--('sheet 1'!A1:A10="john"),--('sheet 1'!B1:B10="sick"))



grizzly6969 wrote:

I posted a Question yesterday and I had to go -- Shane D. posted a good
reply but now I have another -- my Question was; I have a work sheet 1 with
drop down menus and wish to total on sheet 2
John - - sick
ted - - sick
bill -- sick
john -- broken leg
john -- sick
On sheet 2 by johns name it wil show under sick (2) and under broken leg
(1) and so on
Shane D gave me this formula
=sumproduct(--(A1:A10="john"),--(B1:B10="sick"))
It works good but only on the same work sheet. I cant seem to pull the
information off sheet 1 to display it on sheet 2
or I'm putting sheet 1 in the wrong place
--
grizz

--

Dave Peterson