If desired, send your file to me at the address below.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RJanz" wrote in message
...
This overcomes the #Value response but returns a value of 0 when it should
actually have a value.
thanks

"Don Guillett" wrote:

=sumproduct((Source!$A$2:$A$9999="X")*(Source!$C$1 :$C$9999="Y")*Source!$G$1:$G$9999)
not tested but try?

=sumproduct(--(Source!$A$2:$A$9999="X"),--(Source!$C$1:$C$9999="Y"),Source!$G$1:$G$9999)--Don
GuillettMicrosoft MVP ExcelSalesAid
"RJanz"
wrote in
... this
also returns a #Value response, possibly because x and y are textvalues.
thanks "Don Guillett" wrote:
try=sumproduct((Source!$A$2:$A$9999="X")*(Source !$C$1:$C$9999="Y")*Source!$G$1:$G$9999)
-- Don Guillett Microsoft MVP Excel SalesAid Software
"RJanz"
wrote in message
... I'm trying
to add the amounts in a column where two other columns match the
set criteria, however, it is comparing the first cell only to the text
specified. Does anyone know how I overcome this or correct the
formula below?
=IF(AND(Source!$A$2:$A$9999="X",Source!$C$1:$C$9 999="Y"),SUM(Source!$G$1:$G$9999),0)