Counting Consecutive cells in a row with a value greater than zero - how?


S

SeanMc

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
 
Ad

Advertisements

G

Gord Dibben

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
 
Ad

Advertisements

S

SeanMc

Gord Dibben said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top