| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
variable formula
how do i write a formula to do a variable sum calculation. ie i have a column
of numbers in A from A5 going down to A25. in cell F1 i have a value between 1 and 20. this example F1 = 7. so the value in the formula would be A5+ the value in F1 (7) which would equal A12. so the final formual would be =sum(A5:A5+value in f1). =sum(a5:a12) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable formula
Try
=SUM(OFFSET(A5,0,0,F1+1,1)) If this post helps click Yes --------------- Jacob Skaria "LP23294" wrote: how do i write a formula to do a variable sum calculation. ie i have a column of numbers in A from A5 going down to A25. in cell F1 i have a value between 1 and 20. this example F1 = 7. so the value in the formula would be A5+ the value in F1 (7) which would equal A12. so the final formual would be =sum(A5:A5+value in f1). =sum(a5:a12) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable formula
so the final formual would be =sum(A5:A5+value in f1).
=sum(a5:a12) Try this: =SUM(A5:INDEX(A5:A25,F1+1)) If F1 is empty the result will be the sum of A5:A5. -- Biff Microsoft Excel MVP "LP23294" wrote in message ... how do i write a formula to do a variable sum calculation. ie i have a column of numbers in A from A5 going down to A25. in cell F1 i have a value between 1 and 20. this example F1 = 7. so the value in the formula would be A5+ the value in F1 (7) which would equal A12. so the final formual would be =sum(A5:A5+value in f1). =sum(a5:a12) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable formula
thank you
|
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable formula
You're welcome!
-- Biff Microsoft Excel MVP "LP23294" wrote in message ... thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DDE formula with variable | Excel Worksheet Functions | |||
| Using a variable in a formula | Excel Discussion (Misc queries) | |||
| Using a variable in a VBA formula | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
Hybrid Mode
