View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jason
 
Posts: n/a
Default How to count positive changes in a row of data

Thanks too for your help.

"Don Guillett" wrote:

have you tried where 18 is the row
=COUNTIF(18:18,"0")
--
Don Guillett
SalesAid Software

"Jason" wrote in message
...
Help,
I have a row of data across 12 columns (1, 1.1, 1.1, 1.2, 1.4, etc). I am
trying to count the positive changes (i.e., 1 to 1.1, 1.1 to 1.2, etc.)
all
the way across. Is it possible to do this? How?

Many thanks,