How do I selectively sum up a series of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
No Spam Please said:
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.
Click to expand...

Look up SUMIF in Help.
 
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.
 
Back
Top