Thanks for the help; I will give these a try
"Bob Phillips" wrote:
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" wrote in message
...
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