Excel Count Function

[lepton]

Hello Friends,

Im trying to use the countif function in excel and it seems I can get it to work, but only partially. Lets say that in column B I have a series of entries. Some entries have an actual dollar figure, others just have $0. I can get the countif function to count the specified range(say from b1-b3, b4 has the actual sum of b1-b3), what I cant do is get the function to count beyond b1-b3. I also have entries from b6-b10, with b11 as the actual sum of b6-b10 that I would like the countif function to capture. This is what I have so far: =COUNTIF(B1:B3,">0")

Please help.

[lepton]

Okay, I figured it out. Here is the basic formula: =COUNTIF(B4:B6,">0")+(COUNTIF(B9:B13,">0")+COUNTIF(B16:B17,">0")). It will allow you to count thru a range of specified cells only if the value in the cell is greater than zero.