yogi_Count Row By Row How Many Numbers In Each Row Are Smaller Than The Numbers In Row Below

Google Spreadsheet   Post  #2581

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-23-2019

question by: mooflower:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/GiYRp6j8aGA;context-place=topicsearchin/docs/category$3Ahow-do-i
Count number of cells in a range whose value exceeds a cell value located above it
I'm trying to count the number of cells in a range that exceed the value of a cell located just above it.  CountIf doesn't fit, would one of the database functions do it, such as DCOUNTA?  I could of course add it all up using a ternary IF, but that will be a lot of IF statements for a long range.

Example (comma separated values):

4, 5, 4, 3, 4

5, 5, 3, 3, 5

The number of times the lower range exceeds the value above it: 2   (the first and last entries)

Thanks !