Thread: Count formula help. Replace ZERO with "-"
View Single Post
 
Old 04-25-2019, 06:16 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Code:
=IF(COUNTA(G7:G64)="","-",(COUNTIF(G7:G64,"A")*VLOOKUP("A",Cover!G68:H71,2,   FALSE)+COUNTIF(G7:G64,"B")*VLOOKUP("B",Cover!G68:H71,2,   FALSE)+COUNTIF(G7:G64,"F")*VLOOKUP("F",Cover!G68:H71,2,   FALSE))/COUNTA(G7:G64))
Change the 0 to "" in your formula, after the =, then set the number format to accounting, symbol, none.
Attached Files
File Type: xlsm Copy of Community CSR-1.xlsm (147.0 KB, 6 views)
Reply With Quote