How to count positive changes in a row of data
 

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,

How to count positive changes in a row of data
 

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,

How to count positive changes in a row of data
 

Try something like this:

With numbers in A1:L1

This formula counts postive increments.
M1: =SUMPRODUCT(--((B1:L1-A1:K1)0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jason" wrote:

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,

How to count positive changes in a row of data
 

I misread

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
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,

How to count positive changes in a row of data
 

Wow. That gets it done. I'm sure I'll have more questions, but that keeps
me busy for a while.

Thank you very much
-Jason

"Ron Coderre" wrote:

Try something like this:

With numbers in A1:L1

This formula counts postive increments.
M1: =SUMPRODUCT(--((B1:L1-A1:K1)0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jason" wrote:

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,

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,