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

 

[Coyotex3]

Can you post a sample of what your data looks like?

 

[Mldeuser]

The below sample shows the January - May

 

[Coyotex3]

Thank you for the sample. Do you want to sum just the Actuals? Or are you wanting to see the difference etc? Can you tell me which results you'd like summed up?

 

[Mldeuser]

I would like to sum the budget columns that are equal to or less than the date in cell A3, if the date is 03/31/24 it would add the budget numbers for Jan-Mar in column AY. I would also be using the formula to add the actuals that met the criteria in column AZ

Thank you

 

[Coyotex3]

I'm assuming your dates are written as 1/1/2024, 2/1/2024 etc. formatted to show January, February, etc. If that's the case you can use this formula on column AY to get your sum. Drag the formula down for the other account numbers.

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

 

[Mldeuser]

I am using the last day of each month, the formula brought in both the budget and the actual in column AY. I need it to only add the columns were there is the word Budget in row 6 if the date row 7 is equal or less than the date in cell A3

I am not sure how to write a formula that skips columns.

 

[Coyotex3]

Did you paste the formula on post #6 on cell AY3?

 

[Mldeuser]

I posted it into row 8 and updated any ref to row 9 to row 8. When I changed the date in cell a3 to 02/29/24 it sums columns C and D instead of columns C and G

 

[Coyotex3]

Hmmm, that is interesting. Can you post your formula? The formula I provided is looking for the word "Budget" on cell C7. The formula should not be summing column D as the contains the work "Actuals" not "Budget".