View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mayur Mayur is offline
external usenet poster
 
Posts: 10
Default How to put data into different buckets. - PLEASE HELP

I have thousands of rows of data that have one column that I need tohave a
formula that counts how many within three years and puts it into the correct
three different buckets accordingly.
ex.
0-2 3-5 5-10 and so forth.
Columbus
Louisville

i need it to look through one column and when it matches look at the length
of service column and it is between 0-2 it would count as 1 and go to the
next columbus match and length of service and so forth.

After that I need to do the same thing but instead of counting i need the
formula to add up the dollars according to $0-$100, $500-$1000 ect. and sum
up the dollars per market.

PLEASE HELP ME!!!!!!!!!!!!!!!!!!!