Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about Sum
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about Sum
Put this formula
=SUM(INDIRECT("B"&A1):B50) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about Sum
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. -- Biff Microsoft Excel MVP "Keith" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question | Excel Discussion (Misc queries) | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
An if question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |