sum formula based on criteria

[stacylena]

This newbie would appreciate your help! I need a formula to add data in cell e3 with I3 if cell b3 and F3 says DTH and put results in J3.
Thanks!

 

[joeu2004]

Enter the following formula into J3:

=IF(AND(B3="dth", F3="dth"), E3+I3, "")

That returns the null string ("") if the conditions are not met. You neglected to say what to do in that case.

Note: Replace commas (",") with semicolons (";") if that is what you use in your region to separate function parameters.

 

[stacylena]

Enter the following formula into J3:

=IF(AND(B3="dth", F3="dth"), E3+I3, "")

That returns the null string ("") if the conditions are not met. You neglected to say what to do in that case.

Note: Replace commas (",") with semicolons (";") if that is what you use in your region to separate function parameters.

Thanks for your help. If b3 and/or F3 do not say "dth" I don't want anything to appear in the cell or it could say 0. When I try to enter the formula you suggested, I get an error message.

 

[joeu2004]

=IF(AND(B3="dth", F3="dth"), E3+I3, "")

If b3 and/or F3 do not say "dth" I don't want anything to appear in the cell or it could say 0.

That is what the formula does, as I explained. If you want zero, change "" to 0.

When I try to enter the formula you suggested, I get an error message.

When I copy-and-paste the formula as posted, I do not get any error.

As I mentioned, perhaps you need to use semicolon (";") instead of comma (",") between parameters, to wit:

=IF(AND(B3="dth"; F3="dth"); E3+I3; "")

Alternatively, perhaps E3 and/or I3 contains text that Excel does not interpret as numeric. Be sure that ISNUMBER(E3) and ISNUMBER(I3) return TRUE.

If you want the flexibility of E3 and/or I3 containing non-numeric text, use N(E3)+N(I3) instead of E3+I3.

Do those suggestions resolve the problem?

 

[stacylena]

That is what the formula does, as I explained. If you want zero, change "" to 0.



When I copy-and-paste the formula as posted, I do not get any error.

As I mentioned, perhaps you need to use semicolon (";") instead of comma (",") between parameters, to wit:

=IF(AND(B3="dth"; F3="dth"); E3+I3; "")

Alternatively, perhaps E3 and/or I3 contains text that Excel does not interpret as numeric. Be sure that ISNUMBER(E3) and ISNUMBER(I3) return TRUE.

If you want the flexibility of E3 and/or I3 containing non-numeric text, use N(E3)+N(I3) instead of E3+I3.

Do those suggestions resolve the problem?

Thank you! Copying and pasting made it work. I must have been doing something wrong. I appreciate your assistance.