Sum columns based on header name

I have data as follows

Header Actual Actual Actual Forecast Forecast Forecast
Amount 1 1 1 1 1 1
Amount 2 2 2 2 2 2
Total 3 3 3 3 3 3

I need to sum up the total row with any columns with "Actual" in them thus would expect a result of 9.


Thanks in advance

Was trying to use Index and Match

Sometimes the best options are also the simplest.

Thanks