Posted to microsoft.public.excel.misc

SJT

external usenet poster

Posts: 71

Sumproduct Formula

I know the following formula is used to sum every 4th column but was
wondering if someone could tell me what the purpose of the column(6:6) is at
the beginning of the formula as well as the (6:6) at the end of the formula.
Thanks.

=SUMPRODUCT((MOD(COLUMN(6:6),4)=1)*(6:6))

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
Nesting a sumproduct formula within a sumif formula.	jerrymcm	Excel Discussion (Misc queries)	2	October 3rd 07 03:35 PM
SUMPRODUCT Formula	Dan	Excel Worksheet Functions	6	February 21st 07 02:25 PM
Help - Looking for a Sumproduct formula	[email protected]	Excel Worksheet Functions	4	November 1st 06 07:39 AM
sumproduct formula	Todd	Excel Worksheet Functions	2	March 10th 06 01:39 AM
sumproduct formula	Brian	Excel Worksheet Functions	1	December 12th 04 05:21 AM

All times are GMT +1. The time now is 04:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us