Thread: Sum from a Drop down menu using value in the cell below
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default Sum from a Drop down menu using value in the cell below
What are you adding the numeric value too and do the numeric values
necessarily corresponded to the same alpha values all the time?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Kat" wrote:

On a calendar I have two drop down menus - the first has an alphabetic value
(A13)A - E respectively, the second drop down below it (A14) has numeric
values .25 - 10. How do I make it add the numeric value per alphabetic
value?


Thanks - Kat
Reply With QuoteReply With Quote