Dynamic Sum of values in every fourth row

[Ozzie2842]

I am using Excel 2007. I have a table with department names and the number of employees in each department. Currently, I'm using the formula =SUM(C12,C16,C20,C24,C28,C32,C36,C40,C44). However, if another section is added to the database I have to update each formula. I'm looking for a way to get my totals no matter how many sections I add to the table.

 

[preludeofme]

can you add a new column and set it up to be like:

A .| B
1 value | Blank
2 value | Blank
3 value | Blank
4 value | =A4
5 value | Blank
6 value | Blank
7 value | Blank
8 value | =A8

then from there do a sum of column B? and if you needed to add more values to column A you just keep adding formula in column B to every 4th cell?

i know there's a cleaner method but that's an option

 

[Matt Rogers]

Hi.

Another idea:

Excel Workbook
	A	B
1	1	6
2	2
3	3
4	4
5	5
Sheet

 

[Ozzie2842]

The response from screwdriver worked perfectly. I also discovered that it will work with named ranges. Thanks for your help, this will save me time and a lot of work.

Ozzie

 

[Matt Rogers]

Hello Ozzie2842

I'm very happy about your feedback.
All the best and greetings.

Screwdriver