Combine 2 formulas

[N0t Y0urs]

I have 100 data sets that will be grouped into 5 groups. What I want to do is merge the two formulas that work seperately but confuse me when I tried to merge them.

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)

Due to the amount of data that is being reported I’m trying to keep file size down on the file as I was going to do a summary page and use the formulas separately

 

[Fluff]

Duplicate to: Combine formulas

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.