|
Rather than trying to sum every 5th column it should be easier to use SUMIF based on your column headers
I’m not sure exactly which formulas you’re referring to but try this formula in C5 on u19’s worksheet
=SUMIF($I$4:$IO$4,C$4,$I5:$IO5)
copy across to column G and then down
|