Excel - countif

  Bee Jay S 13:45 08 Dec 06
Locked

I have a coloumn with a countif formula, which returns the number of a certain item in a row. Is it possible that when it returns a zero value I could add to the formula to make the cell blank?

  fitshase 13:52 08 Dec 06

Set conditional formatting to the cell to say that if the value=0 set the text to white (hiding the value).

Format\Conditional Formatting....

  Jonathan-290398 14:47 08 Dec 06

Hello

An alternative to fitshase's solution, if you want the cells to actually be blank, would be to add an IF forumla to it - so if the value=0, make it return a blank, or "".

For example, if the previous formula was [=COUNTIF(A1:A5,1)], add [=IF(COUNTIF(A1:A5,1)=0,"",COUNTIF(A1:A5,1)].

Hope this helps.

  Simsy 15:03 08 Dec 06

Tools>Options>View and Untick "Zero Values"

This is a setting for Excel as a whole, not just the worksheet.

Regards,

Simsy

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…