wmichael
Board Regular
- Joined
- Aug 26, 2014
- Messages
- 113
- 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") |