Hi,

I need help. I have an Excel sheet where I need to sum every fifth column. I did manage to do that however when I added a column with text (see the "Column"

It looks like this. In the first column column H I want to summarise the cost from each month (i.e december, january and february), however since I have the column where I will add comments to variances between cost and budget my formula below won´t work. How could it be solved?


Sum all months december january february
Total Cost Total Progress Total Variance Cost Accrual* Progress Variance Comment Cost Accrual Progress Variance Comment Cost Accrual
#VÄRDEFEL! #VÄRDEFEL! #VÄRDEFEL! 275200 115000 345000 -45200 "f" 0 0 0



i hade written the below function

=PRODUKTSUMMA((K4:PZ4)*(REST(KOLUMN(K4:PZ4)-KOLUMN(K4);5)=0)) translated to English version it should be:

=SUMPRODUCT((K4:PZ4)*(MOD(COL(K4:PZ4)-COL(K4);5)=0))

Thanks