Sum Columns A, D, F, H based on date in A3 do this for each row

[Mldeuser]

Hello

I have a spreadsheet that compares the budget to the actuals for each month. I would like to have a formula that can sum the months that are equal to or less than the date in cell A3.

If the date in A3 is 02/29/24 it would add columns C and G in column AY.

Budget columns are C, G, K, O, S, W, AA, AE, AI, AM, AQ, AU

Thank you

 

[Mldeuser]

=SUM(FILTER(C8:AU8,(C8:AU8<>"")*(C$7:AU$7=$C$7)*($C$8:$AU$8<=$A$3)))

 

[Coyotex3]

Your formula should be:

SUM(FILTER(C9:AU9,(C9:AU9<>"")*(C$7:AU$7=$C$7)*($C$8:$AU$8<=$A$3)))

The formula you posted is looking at row 8 which contains the dates. The formula should be looking at row 9. Copy and paste this formula on cell AY9.

 

[Mldeuser]

=SUM(FILTER(C9:AU9,(C9:AU9<>"")*(C$6:AU$6=$C$6)*($C$7:$AU$7<=$A$3)))

This is what I have in AY9 I updated the formula to look at row 6 which contains the word Budget and row 7 which contains the month and it works

Thank you

 

[Coyotex3]

=SUM(FILTER(C9:AU9,(C9:AU9<>"")*(C$6:AU$6=$C$6)*($C$7:$AU$7<=$A$3)))

This is what I have in AY9 I updated the formula to look at row 6 which contains the word Budget and row 7 which contains the month and it works

Thank you

You are right! I overlooked the row numbers. Budget is listed on row 6 and dates on row 7 per your example. Glad you were able to figure it out.