Sum if question
 

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?

Sum if question
 

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

Dave
--
Brevity is the soul of wit.


"Karen Smith" wrote:

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?

Sum if question
 

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)

--
Don Guillett
SalesAid Software

"Karen Smith" wrote in message
...
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?