N0t Y0urs
Board Regular
- Joined
- May 1, 2022
- Messages
- 96
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- MacOS
- Mobile
- Web
Hi all
I have 15 columns of data with 25 rows each. The columns are broken into sets of 3 therefore giving me 5 different groups. These are number 1 - 5, while my rows are numbered 5, 10, … 500, and my columns are labelled FWD, DB and RB
Each group have the same columns but the values are different so what I want to do and get confused is the following:
If my criteria is 3 and 200 I would like to calculate the sum of FWD for the first 3 groups from the first row to the row labelled 200. It would be the same formula for the DB columns but for the RB column it would just be the sum of that column on row labelled 200.
I can get it to work for just one column but when I add the groups in I get confused.
This is what I currently have:
This is for my FWD and DB columns:
=INDEX($D$9:$D$27,MATCH($C$59,$B$9:$B$27))
Where D is group 1 DB, C is my second criteria and B is the row value that criteria is looking for
Then for the FWD column it’s the same only D becomes C
Then my RB column formula is:
=INDEX($E$9:$E$27,MATCH($C$59,$B$9:$B$27))
RB is column E.
So my sheet has these columns:
FWD: C, G, K, O and S
DB: D, H, L, P and T
RB: E, I, M, Q and U
Hope that makes sense as my working file is large. I’m working with 365 and Google sheets.
Thanks in advance
I have 15 columns of data with 25 rows each. The columns are broken into sets of 3 therefore giving me 5 different groups. These are number 1 - 5, while my rows are numbered 5, 10, … 500, and my columns are labelled FWD, DB and RB
Each group have the same columns but the values are different so what I want to do and get confused is the following:
If my criteria is 3 and 200 I would like to calculate the sum of FWD for the first 3 groups from the first row to the row labelled 200. It would be the same formula for the DB columns but for the RB column it would just be the sum of that column on row labelled 200.
I can get it to work for just one column but when I add the groups in I get confused.
This is what I currently have:
This is for my FWD and DB columns:
=INDEX($D$9:$D$27,MATCH($C$59,$B$9:$B$27))
Where D is group 1 DB, C is my second criteria and B is the row value that criteria is looking for
Then for the FWD column it’s the same only D becomes C
Then my RB column formula is:
=INDEX($E$9:$E$27,MATCH($C$59,$B$9:$B$27))
RB is column E.
So my sheet has these columns:
FWD: C, G, K, O and S
DB: D, H, L, P and T
RB: E, I, M, Q and U
Hope that makes sense as my working file is large. I’m working with 365 and Google sheets.
Thanks in advance