View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default "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