If function with Sumifs

HI John,

Thanks for coming back to me.
Could you please amend/update my formular --=IF(B$3="Actual",SUMIFS($B14:$M14,$B$3:$M$3,"Actual"))

I want to sum the actual and forecast separately.

Actual spend todate 98000
Forecast remaining to spend FALSE

Thanks

Actual spend todate 98000

No idea how you get the above

nor do I understand your requirement re the formula.

I used this formaular IF(B$3="Actual",SUMIFS($B14:$M14,$B$3:$M$3,"Actual")) to arrive at £98,000 but I want to tweak it for the Forecast as well. so I can have a total for actual and forecast separately. Thanks

It would appear ( to me) you do not understand the SUMIFs statement.

The formula I provided does exactly what you stated in your expected results

None the wiser so I'll leave this.

Look at the file in post#8.