Excel - countif

  Bee Jay S 13:45 08 Dec 2006

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 2006

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 2006


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 2006

Tools>Options>View and Untick "Zero Values"

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



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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?