Countif with criterias in range

[mnur]

Hi Forum,
I need help to solve this.

Thank you.

[martindwilson]

h3 filled down
=SUMPRODUCT(--($B$2:$G$2>B3:G3))

[mnur]

I'm still using this unefficient formula.
=SUM(COUNTIF(B3;"<"&B2);COUNTIF(C3;"<"&C2);COUNTIF(D3;"<"&D2);COUNTIF(E3;"<"&E2);COUNTIF(F3;"<"&F2);COUNTIF(G3;"<"&G2))

What about hundreds criterias?

[mnur]

I'm still using this unefficient formula.
=SUM(COUNTIF(B3;"<"&B2);COUNTIF(C3;"<"&C2);COUNTIF(D3;"<"&D2);COUNTIF(E3;"<"&E2);COUNTIF(F3;"<"&F2);COUNTIF(G3;"<"&G2))

What about hundreds criterias?

[mnur]

Thank you............

[martindwilson]

so whats wrong with sumproduct?