LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Infinite sum formula

Hi there.

I am looking for a formula that I can use for rows in a worksheet to
calculate a total infinitely.

Basically, I would like two cells in each row to add together to
obtain a total for that row. For example: F6+G6=H6, F7+G7=H7,
F8+G8=H8, etc. However, I would like the formula to continue on
infinitely, no matter how many rows my worksheet will contain.

Does anyone know a formula that would meet this criteria?

Any help would be greatly appreciated!

Thanks!
Jen

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Infinite loop using Worksheet_Calculate Parker Excel Discussion (Misc queries) 2 November 3rd 06 12:25 PM
infinite rows? Pauline Charts and Charting in Excel 1 September 27th 06 08:16 AM
For Next Infinite Loop Naji Excel Discussion (Misc queries) 5 January 13th 06 06:56 PM
Infinite Updating Column murphyslaw18 Excel Worksheet Functions 2 January 13th 06 02:39 AM
How to calculate NPV of an infinite series? Mike Excel Discussion (Misc queries) 2 September 15th 05 06:10 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"