Sum if question

K

Karen Smith

Is there a formula I can use that says if A:A = 408 409, 410, 411, 412 or 415
then put the contents of C:C in column D?
 
D

Dave F

Put this in D1 and fill down as needed: =IF(OR(A1=408, A1=409,
A1=410...A1=415),C1,"")

Dave
 
D

Don Guillett

This will total the c range if the A range(which cannot be a:a) = aa or bb.
Does that help?

=SUMPRODUCT((A9:A19={"aa","bb"})*C9:C19)
 
Top