yesterday countif

[grizzly6969]

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

 

[Dave Peterson]

You can add the sheet names:

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

 

[Dave Peterson]

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]

I tried adding the sheet names but get an error message

 

[Dave Peterson]

I hit send in error.

If you read the other message and that doesn't work, what is the exact sheet
name? Is it really "sheet 1" (with that space character????).

I tried adding the sheet names but get an error message

 

[grizzly6969]

Thanks Dave I didn,t put sheet (1) in both places