VLOOKUP: Sum specific cells

Hi There-
I'm trying to sum any values in a ROW that are in a COLUMN labeled "Actual". Capture.JPG

Currently I am using: =SUM(VLOOKUP($G8,D8:S8,{2},FASLE)) but it's not working. Ideally, I would like to sum values in H8, N8, but NOT R8 (Sum only "Actual" values not "Projected"). I added a column to the left of each cell with the lookup value, hoping I could use that, but to no avail! The goal is that I can continue to add columns/months and not have to keep adding the additional cells to the formula.

THANK YOU in advance!!

Try:

=SUMIFS(8:8,2:2,"Actual")

OMG, brilliant. I know it probably seems simple to you, but I really appreciate the solution, worked like a charm!!