Combine formulas

[N0t Y0urs]

I now want to combine these two formulas.

The concept is 100 data sets that I want to calculate values in 5 groups, and I also have 3 columns worth of data that need calculating.

So assume the following:

Cell D4 is where my criteria value will sit
Cells D6-10 hold my ranges
E5, E6 and E7 are headers for my 3 different values

Then the data is coming from C20:SH520

Row 20 has my data set numbers which I thought I would use <21, <41, <61, <81 and >80
Then row 21 has my Column identifiers for example FWD, RB and DB

So what I want is to total the values in FWD and DB to my criteria value and I only want the RB to reflect that value not the sum.

I am hoping this is easy but happy to be told it’s impossible ?

=if(ACC!$D$3:$EC$3<20,SUMIF(ACC!C$4:EB$4,"FWD",ACC!$D58:$EC58))

=SUMIFS(Totals!$C$13:$C$120,Totals!$D$13:$D$120,"<="&$B$3)

 

[N0t Y0urs]

Revised my question

 

[Fluff]

Please do not mark a post that doesn't contain a solution as the solution.