P PSG Member Aug 23, 2011 #1 Hi I am applying COUNTIF(range,) without any criteria to a range which has reference to other cells in the sheet. Why this formuala is counting only cells where I have 0 in my range?
Hi I am applying COUNTIF(range,) without any criteria to a range which has reference to other cells in the sheet. Why this formuala is counting only cells where I have 0 in my range?
Luke M Excel Ninja Staff member Aug 23, 2011 #2 In XL, putting nothing after the comma is the same as putting 0 or false, depending on syntax.
