Find text in Column to sum
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 |
Find text in Column to sum
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 |
Find text in Column to sum
Hello Frank,
The problem with this is that I'M doing a macro and the rows can change from period to period. So the filldown would not be right. Right now I do have totals in Column B but not formula since this gets downloaded from our system. So need to put a formula because users might just want to view the YTD for some periods. Hope I'm making sense. Please advise with any input. thanks, 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 . |
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 . |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com