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

You can add the sheet names:


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

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

I tried adding the sheet names but get an error message
--
grizz


"Dave Peterson" wrote:

You can add the sheet names:


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

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????).

grizzly6969 wrote:

I tried adding the sheet names but get an error message
--
grizz

"Dave Peterson" wrote:

You can add the sheet names:


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


--

Dave Peterson

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


"Dave Peterson" wrote:

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