I have the formula below:

Code:
=(SUMIF(Feb!$C$3:$C$22,"*MSF*",Feb!$B$3:$B$22))+(SUMIF(Feb!$E$3:$E$22,"*MSF*",Feb!$D$3:$D$22))+(SUMIF(Feb!$G$3:$G$22,"*MSF*",Feb!$F$3:$F$22))
The idea is that each column combo (C and B, E and D, G and F in this case) are figures and namecodes respectively. Each combo is a single day of the month. I need to add the entire month, however, the formula would be so long, it will become unmanageable. 3 days I can handle, 31 is stupid.

Is there a more elegant way of doing this? I don't need to add up each month to make the year, it's just every day of each month.