Question about Sum

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Hello,
In the formula =sum(B6:B50) is there any to make the value represented
here by the “6†a variable? Is there any I could point it to, say, the value
in cell “A1�

Thank you,

Keith
 
Try this:

A1 = 6

=SUM(INDEX(B1:B50,A1):B50)

If A1 is an empty cell the formula will calculate the entire range. If A1 is
a number >50 then you'll get a #REF! error.
 

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

if true, if not nested if funcion 2
Sum Products with VLOOKUP 3
Sum several sheets 3
how to get totals? 1
Define variable range input for SUM() function 8
Formula help again, Please 5
Yearly sum 3
SUM returns #VALUE! error 2

Back
Top