"Simple" countif formula? not for me...
=SUMPRODUCT(--(ABS(G1:G20)ABS(H1:H20)))
--
Regards,
Peo Sjoblom
"Ray" wrote in message
ups.com...
I want to count the number of cells in col H that are less than the
corresponding value in col G -- should be the ABS() of each, since
their will be negative numbers involved.
For some reason, this one is kicking my butt...... :)
//ray
|