Solved I need a count A function to display nothing in a cell

Microsoft Excel 2013 32/64-bit - license...
December 13, 2017 at 19:36:02
Specs: Windows 8
I have a workbook with 6 sheets. The 7th is a master.

The master is set up to count 'yes' from specific ranges on the other worksheets. My function is as follows: =COUNTA('Big Spring:Williston'!D3)

The problem is 0s appear in all the cells on the master sheet. which is confusing and too busy. I would like to have nothing displayed if the count is less than 1... I am trying different IF functions and conditional functions but not having any luck.


See More: I need a count A function to display nothing in a cell

Report •

#1
December 13, 2017 at 21:05:26
Not sure what your doing, but try this:

=IF(COUNTA('Big Spring:Williston'!D3)=0,"","")

MIKE

http://www.skeptic.com/


Report •

#2
December 14, 2017 at 04:21:05
✔ Best Answer
This site covers just about every way to hide 0's. Everything from hiding 0's via a global Excel setting to Conditional Formatting to a formula based solution:

https://support.office.com/en-us/ar...

Let me know if none of these work for you.

BTW...

The function you are using does not just count "yes" values, the COUNTA function counts any value. If you are 100% sure that the cells will only ever contain "yes", then your way will work. However, if you are not using some type of data validation to ensure that nothing other than "yes" can be entered into the cells, your method can result in inaccurate results.

If you are not using data validation, then consider using the COUNTIF function to specifically count "yes" values.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#3
December 14, 2017 at 07:39:36
DerbyDad03

I know counta counts anything in the cell but I've placed "pull down" menu for users to select yes otherwise they do nothing. So I have limited the data allowed in the cells. Thank you for that!

Also with the countif I couldn't figure out how to add +1 each time yes was selected in that cell on the different sheets so I went with counta and pull down menu.

message edited by Daniej


Report •

Related Solutions

#4
December 14, 2017 at 11:21:54
Thank you everyone... I went to the site suggested by DerbyDad03 and it now works great!

Report •

Ask Question