Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

Dynamic formula

Lets say I have some numbers in the range A1:A10 and I have to take a
sum of it in cell B1, I will use the formula =SUM(A1:A10).

My question is, is it possible to detect the last row of the range and
have a dynamic formula?

For instance, the formula should be able to detect A10 (the second
parameter) automatically.

something like =SUM(A1:&count(A:A)) &count(A:A) count will give the
value 10

Sandy

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 create a 'dynamic' formula?	Bill	Excel Worksheet Functions	11	April 22nd 06 07:18 PM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Help with dynamic sum formula	Aussie CPA	Excel Worksheet Functions	4	October 7th 05 05:28 PM
Setting dynamic range in a formula	Phillycheese5	Excel Worksheet Functions	9	June 10th 05 07:58 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM

All times are GMT +1. The time now is 05:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us