| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
| count G4:G51 for critera only if D4:D51 contains text data | Excel Worksheet Functions | |||
| Count data or list | Excel Discussion (Misc queries) | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
| Count data entries and date problem | Excel Worksheet Functions | |||
Linear Mode
