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,