Adding a changing number of cells.

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

Guest

I am trying to add up part of a row of numbers. The number of cells in the
row that I am trying to add will change depending on a variable in another
cell. For instance, if there are numbers in the range a1:t1, I am trying to
obtain the sum of the range that will always start with cell a1 and end with
?1 where "?" corresponds to a number in cell b1. The number in b1 is a
variable and will change occasionaly based on other conditions. So if the
number in cell b1 is "6" I would want the sum of a1:f1.

Does anyone have a suggestion?

Thanks,

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Formula with variable range 2
Adding 2 columns 1
Different cells that need to sum in one 4
Conditional Format Range of Cells 3
Excel Need Countifs Formula Help 0
Set add function ignore #N/A 1
Sum number range ignoring numbers formatted as text 0
Numbers showing Up Centered in Cell ? 1

Back
Top