sorting data from pull down menus

  • Thread starter Thread starter pyzikchr
  • Start date Start date
Hi Pyzikchr

it's better to ask your question by typing out an example or two in your
posts, most ng readers will not open attachments because of the risk of
viruses etc ...

bascially in this situation you need to use the SUMIF function
so for E9
type
=SUMIF($C$4:$D$7,C9,$E$4:$E$7)
where
=SUMIF(range_to_check_for_criteria, criteria, range_to_sum)

you can then "fill" this down (move cursor over the bottom right of the cell
until you see a +, then hold down the left mouse and drag this as far as
necessary) for the other two types.

Regards
JulieD
 
Very few will open attachements due to viruses. It is best to just post a
specific question with example of the code that is not working

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Back
Top