Find text in Column to sum
Hello Frank,
FYI, I made some changes to a code I had that uses Rows.
And it seems that its doing what I want. So once again,
thanks alot.
Juan
-----Original Message-----
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
.
|