Hi
try
=IF($B$1="YTD Total",SUM(C2:N2),"")
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


Juan wrote:
Hello All,
I have in Column B YTD Total. I want to be able to sum
columns C To N if Column B contains text YTD Total has the
header. And then I want to fill down, but total rows can
change. Example,
Colum B
row 1 YTD Total
row 2 =SUM(C2:N2)
Then filldown

Hope this makes sense any help would be appreciated.

Thanks,

Juan