In function =Sum(A#:B#) how can I make # a formula so I can copy p

N

No expert

If I use the function =SUM(A#:F#), I will get a sum for a matrix. Now I would
like to substitute the #'s with formulas which calculate the row for each
column (A,F). Thereafter, I would like to copy the function with the formulas
to other cells.
 
R

Roger Govier

Hi

Try
=SUM(INDIRECT("A"&X1&":F"&X2))

Where X1 and X2 are the cell references containing the formulae that
calculate the row numbers required
 

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 paste data from a column to a row 0
Sum Total 2
Error when using Sum command 3
How to copy the function SUM but offseted in 7 columns 2
Sum / Lookup 9
Copy a formula using Vlookup 2
Adjusting formula for month in vlookup? 3
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA 3

Top