I have a list of project numbers, their monthly sales, and, 5 categories
the projects fall into. For each month, I need to associate the project
numbers with the five categories, and, sum the monthly sales for each
category. (i.e. be able to paste the row of project numbers and
associated sales into a spreadsheet and be able to produce the monthly
sales of each of the 5 categories
e.g.

project # category

<4000 S
4101 O
4102 C
4103 G
4104 I
4105 G
4106 C
4107 O
4108 O
4109 C


project# sales category (S, O, C, G or I) sum of sales

4106wb $11,664.00 ? sum of S =
4117 $581.81 sum of O =
1026 $41.56 sum of C =
1040 $573.02 sum of G =
SK00 $1,332.90 sum of I =
KR00 ($1,367.22)
WS00 ($319.63)
4093 $24,920.00
1040 $12,319.00
4118 $159,773.75

This is a little beyond my excel knowledge, but this is what I have so far
for associating the project numbers to the assigned category:

=IF(4000<A7<5000, VLOOKUP(A7,A1:B10,2), "S")

This sort of works if there are no letters in project numbers (they have no
meaning for this purpose), and I still need sum the sales….

Any help?

Thanks, Jeremy

--
Message posted via http://www.officekb.com