Adding cell range when a condition that another cell is inputted

[Turkish Delight]

Hi All,

Can I please ask for your help in this?

I am have the table as below snipit.

I would like a formula please in yellow cell C19 that adds Budget column from Month 1 to what ever month there is a value under corresponding Actual Column F. So in this example below, as I have value of "10" for Month 3 Actual under F5.. so I would like a formula please to SUM E3:E5 [month 1 to 3 Budget] in C19.

If I then add a value in Month 4 in Actual cell F6 then C19 yellow cell to SUM E3:E6 [month 1 to 4 Budget] etc

Hope this makes sense let me know if not.

many thanks in advance!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUMIFS(E3:E14,F3:F14,"<>")

 

[Turkish Delight]

Thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.