Count formula help. Replace ZERO with "-"

		Microsoft Office Forums > Microsoft Excel > Excel
Count formula help. Replace ZERO with "-"

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-25-2019, 05:26 PM

baes10

Windows 7 64bit Count formula help. Replace ZERO with "-"

Office 2007

Advanced Beginner

Join Date: Dec 2017

Posts: 33

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

Formula.JPG (223.9 KB, 16 views)

Attached Files

Community CSR.xlsm (152.5 KB, 7 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to format "I" column based on if "F" column row is not blank	ravl13	Excel	3	08-22-2017 12:26 PM
Replace "comma" with "and" in line of text	audioman	Word VBA	7	01-21-2016 03:11 PM
How to replace e-mail address with "Dispaly as:" name of the Outlook Contact.	RobertF	Mail Merge	1	06-30-2013 09:54 AM
replace data from variable with "sub and super script" from excel to word by vba	krishnaoptif	Word VBA	9	06-22-2012 05:08 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 AM.