Variable Determines Number of Cell in Formula Range

M

MJSlattery

If each cell in column B represents the sum of X number of cells i
column A. How do I get a variable in the formula to include more o
less column A cells within each cell formula in column B.

The real world problem is stock prices in column A and the sum o
between 1 and 30 of those contigent prices in column B. So cell B
would include the sum of cells in the range between A1 and A30
depending on the value in C1. B2 would include the sum of between A
and A31, all B cell ranges would depend on the value in C1.

Don't know how to configure the formula to let the value of the slide
(C1) to chang the desired included range.

Thanks for the assistance,

Michael Slatter
 

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

Copy addition formula of non-consecutive horizontal cells 2
Sum of Variable Cells in a fixed Row 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Show value from one cell in another cell if today falls between a date range 5
Applying a formula to multiple values within a single cell? 1
Count if data falls within a range AND that has a certain criteria 1
Counting multiple occcurrences between date range 3
VBA range selection question 24

Top