Search results

I have a table (approx 600 lines) of sales persons initials in one column and another column with tons sold for each sales person. I would like a formula that would look through all 600 lines and provide just one output reference for each person. ' A Sales 1 EJM 2 JB2 3 EJM 4 DLL 5...

Here is a sample result for 2011 thanks to your help! 2011 0-50 50-100 100-200 200-400 400-600 600-800 >800 Totals Jan 179 156 115 0 0 0 0 450 Feb 144 65 154 839 1,307 0 0 2,509 Mar 169 278 380 565 552 0 1,150 3,094 Apr 205 202 0 843 462 780 0 2,492 May 359 264 220 276 0 0 0 1,119...

You all are brilliant! Thank you so much for your help. I believe I have been able to get the formula to work, but not without your help! I needed to be able to sum tons between >0<50 , >50<100 etc... for months Jan through Dec for any given year. I change the year by keyin...

Thank you all for looking into this, you are all the greatest. The formula below is getting closer. It returns the number of jobs >0<50 = 5 jobs in this range, now how can I get it to return the sum of tons for this criteria of >0<50 etc...

Hui, thanks for your reply. I have managed to get this far but it gives me a REF error. I need to have 3 sheets , one for each year, say 2010, 2011, 2012 and another sheet for review of data from previous years. I need to be able to filter and populate tons >0<50, and say...

I have 3 tabs for years 2010, 2011, 2012, each year has a column for months and a column for tons(different values in each year). I have another worksheet where I would want to populate tons >0 <50, >51<100, >101<200 and so on.. for each month of each year. This...