I have 7 cells in a row (D39:J39). Default value of these cells will be
0.00.
I want a cell to display the count of cells whose value is greater than
zero. How do I do this?
I was looking at DCount - but from the documentation in help that I looked
at, the values tested need to be in a column. - is this correct.

Any example will be appreciated -
Thanks - Sean

Hi Sean

try

=COUNTIF(d39:j39,">0")

hth

Keith

"Keith74" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Sean
>
> try
>
> =COUNTIF(d39:j39,">0")
>
> hth
>
> Keith
>

Great - thank you

Note: this counts all cells in the row that are >0

Does not give a count of Consecutive cells as your subject line asked for.

But "great" sorta says it all.


Gord Dibben MS Excel MVP

On Thu, 31 May 2007 08:33:57 -0400, "SeanMc" <(E-Mail Removed)> wrote:

>
>"Keith74" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> Hi Sean
>>
>> try
>>
>> =COUNTIF(d39:j39,">0")
>>
>> hth
>>
>> Keith
>>
>
>Great - thank you
>

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Note: this counts all cells in the row that are >0
>
> Does not give a count of Consecutive cells as your subject line asked for.
>
> But "great" sorta says it all.
>

Sorry - Guess my typing fingers were working faster than my brain. COUNTIF
does exactly what I wanted.