I have a large data set with each different row being a different entity and many columns of calculations and inputs for that entity. I need to sum a variable number of columns of data depending on the age in column A for that particular entity.
In other words I have each possible age in columns AG:CQ and I want to sum from AG to whatever column matches the actual age in A. I assume some version of index, match and possibly sumif is what I need to combine.
A. AG. AH. AI. AJ. AK. AL. AM. AN. AO. AP. AQ. AR. AS
1. age. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32
2 25
3. 31
So for the patient in row 2 I would want to sum from AG2:AL2 but for the patient in row 3 I would want to sum AG3:AR3
Maureen
Excel for Mac v 16.42
In other words I have each possible age in columns AG:CQ and I want to sum from AG to whatever column matches the actual age in A. I assume some version of index, match and possibly sumif is what I need to combine.
A. AG. AH. AI. AJ. AK. AL. AM. AN. AO. AP. AQ. AR. AS
1. age. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32
2 25
3. 31
So for the patient in row 2 I would want to sum from AG2:AL2 but for the patient in row 3 I would want to sum AG3:AR3
Maureen
Excel for Mac v 16.42