Thread: frequency
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LESLIE LESLIE is offline
external usenet poster
 
Posts: 113
Default frequency

I am trying to find the freqency for C2:C62. the bins are 49.99,
59.99,69.99,79.99,100 in G7...G11
I did this: =FREQUENCY(C2:C62,G7:G11) the answer for the first bin is
right, but it repeates it for all the other bins. what formula should I put
in H8,h9,h10 and h11?
leslie
the date works now. cell not formated to general