View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] StarShackr@yahoo.com is offline
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