Problem with Sumproduct

M

Maureen

I need to count the number of items that have the designation of "R" (Column
A) and that also have a designation of "1" (Column B). I have tried several
different formulas, but always get the return value of "0" (Zero).

Formulas tried:
=sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1"))
={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))}
=SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1"))

Any ideas?
 
L

Luke M

You probably have the "1" entered as a number, not text. Thus, no need for
quotation marks.
=SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126=1))

Of note, you said columns A & B, but your formulas use G & T. I'm assuming
you really meant the latter.
 
B

Bob Phillips

This should work

=SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126=1))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Maureen said:
I need to count the number of items that have the designation of "R"
(Column
A) and that also have a designation of "1" (Column B). I have tried
several
different formulas, but always get the return value of "0" (Zero).

Formulas tried:
=sumproduct(('Test Map'!G4:G126="R")*('Test Map'!T4:T126="1"))
={SUMIF(('Test Map'!G4:G126= "R")*('Test Map'!T4:T126= "1"))}
=SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126="1"))

Any ideas?

__________ Information from ESET Smart Security, version of virus
signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com



__________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
D

Dave Peterson

if that value is really a number (not text), I'd try:

=sumproduct(--('Test Map'!G4:G126="R")),--('Test Map'!T4:T126=1))
 
M

Maureen

Thanks for the help; I will give these a try

Bob Phillips said:
This should work

=SUMPRODUCT(('Test Map'!$G$4:$G$126="R")*('Test Map'!$T$4:$T$126=1))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)





__________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top