ExcelNovice
Well-known Member
- Joined
- May 12, 2002
- Messages
- 583
I'm working with a fairly large spreadsheet of 185 columns and about 2000 rows.
In the cells in row 5 are codes (ex: 4010, 4020, 4030 etc). Each column starting at row 8 has numerical data.
I'm looking for a formula that allows me to sum the values in a column based on the code in each in row 5.
Example: If 4020 is found in a cell in row 5, sum the values in that column starting at row 8.
Thanks for your help.
In the cells in row 5 are codes (ex: 4010, 4020, 4030 etc). Each column starting at row 8 has numerical data.
I'm looking for a formula that allows me to sum the values in a column based on the code in each in row 5.
Example: If 4020 is found in a cell in row 5, sum the values in that column starting at row 8.
Thanks for your help.