Summing Non Contiguous Cells in a Row or Column

Joe Ottenhof · #3 12-18-2012, 07:04 AM

Quote:

Originally Posted by Kevin@Radstock

Hi Joe Ottenhof

Two methods assuming data is in A1:A1000:

1/ =SUMPRODUCT(--(MOD(ROW(A1:A1000),4)=0),A1:A1000)

2/ =SUM((MOD(ROW(A1:A1000),4)=0)*(A1:A1000))
This is an array formula: CTRL + SHIFT + ENTER

You can change what rows to sum, by changing the MOD part ie: =0 to = 1 or 2 etc

Kevin

Kevin
Thanks very much. The second way works perfectly. The first one gives me an error. I paid a guy $38 and he didn't get the answer...so once again thanks,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically enter date into a column and make that column read only	Mr Davo	Excel	1	10-29-2012 01:07 AM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column	carpat	Excel	0	01-10-2012 09:34 AM
Construct a summary sheet by summing up from one or more than one sheet.	PRADEEPB270	Excel	1	11-04-2011 03:46 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
SUMMING TWO COLUMNS	LOGISTICS1	Excel	1	04-18-2006 06:00 AM