View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Problem with Sumproduct

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Maureen" wrote:

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?