In my attached worksheet, I have a sheet with a list of players, their position, and their projected stats for the upcoming season.
I'm trying to have the totals of Columns I:R add up in row 44 based on the position listed in column B.
For the gold cells hitting, I would only like it to add to the totals in cells I44:M44 if one of the following positions (C,1B,2B,SS,3B,INF,CI,MI,OF,LF,CF,RF,DH,UTIL) is listed next to the players name. Also, for the blue cells pitching, I would only like it to add to the totals in cells N44:R44 if one of the following positions (SP,RP,P) is listed next to the players name.
The positions listed in column B will always be changing depending on the amount of players for each team so I need the formula to apply all the way down to row 43 even though there are no players listed in rows 30 to 43 currently.
Please let me know if there are any questions, thanks very much!