Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |