View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default COUNTIF....how to use =0 but <9 as CRITERIA

Harshawardhan and Mike thanks for the info.

Mike yours works as suggested.

thanks for the info on FREQUENCY function.

Harshawardhan is it possible for you to send me an excel sheet with what you
describe in it?

Possibly make a list of 30 or so random numbers between 0 and 99..write the
coding for the frequency function and email it to me.

If you have the time?

My email is



THANKS