Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I want
it to count each time Column D='apple'. So it should only be looking at the
rows where S=Jane. How can this be done? Thanks.

one way:

=SUMPRODUCT(--(S1:S1000="Jane"),--(D1:D1000="apple"))

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"A. Toczko" wrote:

Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I want
it to count each time Column D='apple'. So it should only be looking at the
rows where S=Jane. How can this be done? Thanks.

If doesn't accept the formula. Where have I gone wrong?

=SUMPRODUCT(--('Data!'$S$2:$S$2000="Jane"),--('Data!'$D$2:$D$2000="apple"))

"JE McGimpsey" wrote in message
...
one way:

=SUMPRODUCT(--(S1:S1000="Jane"),--(D1:D1000="apple"))

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"A. Toczko" wrote:

Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I
want
it to count each time Column D='apple'. So it should only be looking at
the
rows where S=Jane. How can this be done? Thanks.

Try removing the single quotes around Data:
=SUMPRODUCT(--(Data!$S$2:$S$2000="Jane"),--(Data!$D$2:$D$2000="apple"))

Or move them
=SUMPRODUCT(--('Data'!$S$2:$S$2000="Jane"),--('Data'!$D$2:$D$2000="apple"))

(excel will remove them if you don't need them--and a worksheet named Data won't
need them.

"A. Toczko" wrote:

If doesn't accept the formula. Where have I gone wrong?

=SUMPRODUCT(--('Data!'$S$2:$S$2000="Jane"),--('Data!'$D$2:$D$2000="apple"))

"JE McGimpsey" wrote in message
...
one way:

=SUMPRODUCT(--(S1:S1000="Jane"),--(D1:D1000="apple"))

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"A. Toczko" wrote:

Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I
want
it to count each time Column D='apple'. So it should only be looking at
the
rows where S=Jane. How can this be done? Thanks.

--

Dave Peterson

Hi!

Put the apostrophe on the other side of the exclaimation point:

'Data'!

You don't need them unless the sheet name contains spaces.

Sheet name = Data = not needed = Data!
Sheet name = Data 1 = needed = 'Data 1'!

Biff

"A. Toczko" wrote in message
...
If doesn't accept the formula. Where have I gone wrong?

=SUMPRODUCT(--('Data!'$S$2:$S$2000="Jane"),--('Data!'$D$2:$D$2000="apple"))

"JE McGimpsey" wrote in message
...
one way:

=SUMPRODUCT(--(S1:S1000="Jane"),--(D1:D1000="apple"))

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"A. Toczko" wrote:

Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I
want
it to count each time Column D='apple'. So it should only be looking at
the
rows where S=Jane. How can this be done? Thanks.

Thanks! I tried removing the apostrophe and it worked. I'll also remember
the placement for other uses as well.

"Biff" wrote in message
...
Hi!

Put the apostrophe on the other side of the exclaimation point:

'Data'!

You don't need them unless the sheet name contains spaces.

Sheet name = Data = not needed = Data!
Sheet name = Data 1 = needed = 'Data 1'!

Biff

"A. Toczko" wrote in message
...
If doesn't accept the formula. Where have I gone wrong?

=SUMPRODUCT(--('Data!'$S$2:$S$2000="Jane"),--('Data!'$D$2:$D$2000="apple"))

"JE McGimpsey" wrote in message
...
one way:

=SUMPRODUCT(--(S1:S1000="Jane"),--(D1:D1000="apple"))

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"A. Toczko" wrote:

Hello. This is what I want to do:

I want it to look at two columns in a spreadsheet. If Column S=Jane, I
want
it to count each time Column D='apple'. So it should only be looking
at the
rows where S=Jane. How can this be done? Thanks.