Microsoft Office Forums - View Single Post - Summing Non Contiguous Cells in a Row or Column

Thread: Summing Non Contiguous Cells in a Row or Column

View Single Post

Old

12-18-2012, 01:46 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 7 32bit

Windows 7 32bit Kevin@Radstock uses Office 2010 32bit

Kevin@Radstock uses Office 2010 32bit

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

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

Reply With Quote