How to count cells in a column those are matching a certain criteria?

[live.arnab]

Hi friends,

I require to write a formula on excel which I tried, but no luck and need the help from this great forum. Please see the expression stated below:

(1) COUNT THE NUMBER OF "CELLS" IN A COLUMN (SAY "B"), CONTAINING NUMERICAL VALUES, THOSE ARE GREATER THAN (IN VALUES) OF CELLS OF COLUMN "A" IN SUCH A MANNER >>>

COMPARE ONLY BETWEEN - "B2" WITH "A1", "B3" WITH "A2", "B4" WITH "A3", "B5" WITH "A4" AND SO ON.........
FOR AN EXAMPLE, IF B2>A1, B3<A2, B4>A3, B5>A4, B6<A5, B7>A6 THEN THE VALUE OF THE "RESULT" WILL BE (DISPLAYING IN CELL "C1") = 04.

(2) SAME WAY, FORMULA TO COUNT NO. OF CELLS (COLUMN "B"), VALUES LESSER THAN COLUMN "A" (COMPARING IN SAME MANNER STATED PREVIOUSLY).

HERE, NOTE THAT, THE "RESULT" WILL BE EXCLUDES OF THE CELLS, THOSE ARE "EMPTY" OR "VALUE=0".

A B
773.04 769.60
800.55 797.65
803.73 801.44
801.03 797.17
815.91 813.65
813.82 810.10
829.06 827.32
830.82 826.55
848.42 844.54
838.24 835.98
843.33 841.83
836.02 833.20
845.24 843.22
829.30 826.90
830.42 828.82
820.02 817.91
807.09 805.26
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00

Thanks in advance.

N.B. : ATTACHED PLEASE FIND THE MANUALLY COMPLETED XLS FILE FOR YOUR EASY UNDERSTANDING.

Rgds,
Arnab

[icestationzbra]

in C2:

=SUMPRODUCT((B3:B26>0)*(A2:A25>0)*(B3:B26>A2:A25))

in D2:

=SUMPRODUCT((B3:B26>0)*(A2:A25>0)*(B3:B26<A2:A25))

observe that the ranges are staggered (offset by 1 row).

the underlying assumption is that there will absolutely be no textual values in either of those ranges.

[live.arnab]

Thanks, you are such a genius my frend!....thanks a lot. It's working fine.....cool. I would like to add few more conditions into my formula, on which I'm working now. If I fail, I'll ask your expertise again. And hope I'll continue to get your support.

Rgds,
Arnab