Posted to microsoft.public.excel.worksheet.functions

Jay

external usenet poster

Posts: 671

Summing values incolumns from row cell L7...

Is it possible to Sum every 5th cell in a range of cells (i.e.
L7+L12+L17+L23....in a range of L1: L45) without entering every cell
manually?
From cell L7 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks

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 lookup multiple values and summing them up in one cell	Amr Abul Laban	Excel Worksheet Functions	7	April 19th 10 02:57 PM
Format cell color based on multiple cell values	Zenaida	Excel Discussion (Misc queries)	1	May 10th 06 07:31 PM
Format cell color based on multiple cell values	Zenaida	Excel Discussion (Misc queries)	3	May 9th 06 11:56 PM
How can I break values apart that are in the same cell?	Phil	Excel Worksheet Functions	3	October 4th 05 03:41 PM
set hypothetical values for a cell	chris8715	Excel Worksheet Functions	1	February 22nd 05 05:18 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us