Excel - countif

  Bee Jay S 13:45 08 Dec 2006
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 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

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 2006

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.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone