Posted to microsoft.public.excel.programming

Abdul

external usenet poster

Posts: 35

using a variable in the sum function

I am trying to sum a column with the sum function say : sum(a1:a12)
however I don't always want it to add row 1 to row 12

depending on an inputted number I want to add a3 to a12, or a5 to a12, or
somthing like that
is there a way I can make the sum function do that or is there any other way
to sum up a column from row x to row 12 or something like that

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to run a function from a variable	Gussie	Excel Programming	4	October 30th 08 12:26 PM
Variable function	ESP Tom	Excel Discussion (Misc queries)	1	July 10th 06 09:37 PM
Variable function	ESP Tom	Excel Discussion (Misc queries)	2	July 10th 06 04:01 PM
Variable function	ESP Tom	Excel Discussion (Misc queries)	0	July 10th 06 02:15 PM
Using variable in a function	alvin Kuiper	Excel Programming	0	February 8th 06 09:43 PM

All times are GMT +1. The time now is 11:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us