Thread: Count formula help. Replace ZERO with "-"
View Single Post
 
Old 04-25-2019, 05:26 PM
baes10 baes10 is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default Count formula help. Replace ZERO with "-"
Hello, I've got a formula I need help in cell block F67, May Tab. Currently showing 0.00 but I need it to return a "-" if all of column G7:G64 is BLANK. Can you help adjust my formula?

Currently:
=IF(COUNTA(G7:G64)=0,"-",(COUNTIF(G7:G64,"A")*VLOOKUP("A",Cover!G68:H71,2 , FALSE)+COUNTIF(G7:G64,"B")*VLOOKUP("B",Cover!G68:H 71,2, FALSE)+COUNTIF(G7:G64,"F")*VLOOKUP("F",Cover!G68:H 71,2, FALSE))/COUNTA(G7:G64))

Much appreciated.
Steve
Attached Images
File Type: jpg Formula.JPG (223.9 KB, 14 views)
Attached Files
File Type: xlsm Community CSR.xlsm (152.5 KB, 5 views)
Reply With Quote