SUMIF question every 6 Rows, and updates when I add more data

[micool1010]

Hi All,

I am really stuck here.

I have a table where in column A I have various bits of info, every 5 rows there is a "TOTAL" row

Then this TOTAL Row is split into sub-total by columns STE, STP, RCA ST.

Also the table grows every day, including table headers.

I need to TOTAL STE for every date (every 6th rows in the table has this info) currently I have =SUM(C30,C24,C18,C12,C6,C36) but it is a nightmare to do manually.

Also, I need to make this automatic:

=SUM(C12,C6,E12,E6,F12,F6,C18,E18,F18,F24,E24,C24,C30,E30,F30,C36,E36,F36)

So I am picking the TOTALs of the STE, STP and RCA ST and totalling them for every date, and for it to update everytime I add a new date to the table.

I need to be able to copy and paste the new table every day and the formulae to auto update.

I am so confused

 

[James006]

Hi,

In order to sum every 6th row, you could test following :

=SUMPRODUCT((MOD(ROW($C$1:$C$36),6)=0)*($C$1:$C$36))

HTH

 

[Jonmo1]

Can you post an example of your sheet using an HTML tool like Excel Jeanie (see my signature for a link)

It seems to me that you could use the word "Total" in some form of SUMIF(s) function.
But it's difficult to visualize your data.