How to count positive changes in a row of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
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
 
You must log in or register to reply here.

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

Similar Threads

return cells below stop when word found 1
Display page number in footer based upon pages in the current tab 1
octogonal repeat? 5
to turn off Auto editing of cell 3
Converting Baseball Innings when Summed 1
Formula Help 4
Automatically renumbering in multilevel lists 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top