How do I selectively sum up a series of numbers?

[Guest]

I have a column filled with numbers, but I only want to sum up a few of them.

Let's say I have numbers filling A1:A10. Let's say I only want to sum up
the numbers located is A3 and A4. I'd like to ability to enter something in
the b column (e.g. "y" in cells b3 and b4) and have a formula that adds up
the values in the "A" cells that have a corresponding "y" in the "B" column.
This formula would allow me to selectively choose which cells needs to be
summed.

What is the best/cleanest way to write that formula? Thank you.

 

[Gordon]

I have a column filled with numbers, but I only want to sum up a few of them.

Let's say I have numbers filling A1:A10. Let's say I only want to sum up
the numbers located is A3 and A4. I'd like to ability to enter something in
the b column (e.g. "y" in cells b3 and b4) and have a formula that adds up
the values in the "A" cells that have a corresponding "y" in the "B" column.
This formula would allow me to selectively choose which cells needs to be
summed.

What is the best/cleanest way to write that formula? Thank you.

Look up SUMIF in Help.

 

[DPelch]

So if you have numbers in A1 to A10, you want to add just a few of them
together in a cell in column B. Is that right?

Also, will the cells in column A, that you select to add together,
change from time to time? Meaning, one time you will add A1, A3, and
A4. While another time you will want to add A3, A7, and A8.

 

[Alan Beban]

Look up SUMIF in Help.

=SUMIF(B1:B10,"y",A1:A10)

Alan Beban

 

[Guest]

Thank you

=SUMIF(B1:B10,"y",A1:A10)

Alan Beban

 

[Guest]

Thanks.

Look up SUMIF in Help.

 

[Guest]

I got it. Thank you.