SUMIFS can criteria1 be a range and criteria2 be a single cell in a sumifs statement

[jas64]

=SUMIF($A$1:$A$47,"=4",C1:C47) --> This was my simple formula before. Simply sum C1 to C47 if A1 to A47 contain 4.

=SUMIF($A$1:$A$47,"=4",AND N53="YES",C1:C47 ---> Now I want to add an "AND/IF" C53="YES" (If C53 = "NO", return 0) =SUMifs((A1:A47,"=4")*(C53="yes")*C1:C47,0) ---> My attempt which doesn't work. Can I even use a single cell reference (C53=YES).???

<tbody>
</tbody>

 

[jtakw]

Hi,

Try it this way:

Book1
	D
1	0
Sheet89

Cell Formulas
Range	Formula
D1	=IF(C53="YES",SUMIF($A$1:$A$47,4,C1:C47),0)

 

[jas64]

Thank you very much! That solves my problem.

 

[jtakw]

You're welcome.