Combining IF, ANd and SUM functions in a formula
"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$999 9="Y"),SUM(Source!$G$1:$G$9999),0)
or, you need a SUM formula as
follows:=IF(AND(SUM(Source!$A$2:$A$9999)="X",SUM(S ource!$C$2:$C$9999)="Y"),SUM(Source!$G$1:$G$9999), 0)
FLKulchar
|