N0t Y0urs
Board Regular
- Joined
- May 1, 2022
- Messages
- 96
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- MacOS
- Mobile
- Web
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 ?
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
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