wmichael
Board Regular
 Joined
 Aug 26, 2014
 Messages
 103
 Office Version

 365
 2019
 2007
 Platform

 Windows
 Mobile
Hello. I am asking for your help to develop a formula that if cells across multiple columns BP, BS, BT are equal "1" then to place the contents from the corresponding cell in column CQ in column BU. Thank you in advance for your help.
Cell Formulas  

Range  Formula  
BP1  BP1  =CONCATENATE(SUM(BP2:BP1780), " Sober Skipper Program") 
BQ1  BQ1  =CONCATENATE(TEXT(SUM(BQ2:BQ1420),"#,##0")," Sober Skipper Impressions") 
BR1  BR1  =CONCATENATE("Sober Skipper Impressions Valued at $",TEXT(SUM(BR2:BR2010),"#,##0")) 
BS1  BS1  =CONCATENATE(SUM(BS2:BS1780), " North American Sober Skipper Advisory Council") 
BT1  BT1  =CONCATENATE(SUM(BT2:BT1780), " National Boating Industry Safety Awards") 
BQ3:BQ27,BQ324:BQ343,BQ180:BQ322,BQ173:BQ177,BQ29:BQ171  BQ3  =IF(BP3=1,CQ3,"0") 
BR3:BR27,BR324:BR343,BR180:BR322,BR173:BR177,BR29:BR171  BR3  =IF(BP3=1,CR3,"0") 