Variable in Excel Sum formula

Posted to microsoft.public.excel.misc

KMR

Posts: n/a

Variable in Excel Sum formula

I have a list of rows with columns A1 to H1. Based on some criteria, I need
to sum from A1 to H1 or E3 to H3 or any possibility. If I store the
beginning cell in a cell like J1 or J3, how can I use the value of the cell
and not the cell itself? I want something like sum(actual value of
cell(J1):ending cell))

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
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	3	January 19th 06 09:52 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
How can i get an If formula in excel to edit another cell?	Jimmy Hoffa	Excel Worksheet Functions	2	August 16th 05 05:53 PM
converting formula from lotus.123 to excel	zaharah	Excel Worksheet Functions	2	July 27th 05 03:04 PM
How do I view the actual numeric value of a formula in Excel 2002.	Excel Function Help	Excel Worksheet Functions	0	January 13th 05 10:07 PM

All times are GMT +1. The time now is 11:41 PM.

Menu

About Us