Formula help!

Closed
Report
-
Hello,

I need a formula that will sum a row based on the column header.
I need B5:DC5 to sum based on b4:DC4.
B4:DC4 has calls, apps, %. these three columns are repeated through (B3:DC3 are the three columns merged with employee names)


I have tried a few with sum(IF.... But keep getting 0 as a result)
Ive tried sum(vlookup.... but keep getting a #NA error