The formula for how to total different amounts in non-consecutive cells. Please.

Question

in cell b10 add the total amounts for A2 bedtime set with amount in B2, A3 corduroy pants with amount in B3, & A8 inorganic kit with amount in B8, using a formula with cell references. So: just the formula for how to total different amounts in non-consecutive cells. Please.

Answer 1

You can get your desired result either by using the SUM function placed in cell B10 (Method 1 below) or by placing the mathematical formula as described in Method 2 below:

1. Method 1: =SUM(B2,B3,B8)
2. Method 2: =B2+B3+B8