Formula help!

Ashley - Nov 25, 2017 at 12:59 PM

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