| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum from a Drop down menu using value in the cell below
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
The value needs to be 0, itself or added to any other cell that used A - E
respectively during the month. And no each numeric value is chosen based on the amount of time spent on a given day. Kat "M Kan" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
In A13, what values do A through E represent?
-- John C "Kat" wrote: The value needs to be 0, itself or added to any other cell that used A - E respectively during the month. And no each numeric value is chosen based on the amount of time spent on a given day. Kat "M Kan" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
A = Annual Meeting
B = BOD Meeting C = Contractor Meeting Then the numerical value in the drop down menu below equals the amount of time spent at the meeting. "John C" wrote: In A13, what values do A through E represent? -- John C "Kat" wrote: The value needs to be 0, itself or added to any other cell that used A - E respectively during the month. And no each numeric value is chosen based on the amount of time spent on a given day. Kat "M Kan" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
=SUMIF(A13:Z13,"A",A14:Z14)
-- Regards, Peo Sjoblom "Kat" wrote in message ... A = Annual Meeting B = BOD Meeting C = Contractor Meeting Then the numerical value in the drop down menu below equals the amount of time spent at the meeting. "John C" wrote: In A13, what values do A through E represent? -- John C "Kat" wrote: The value needs to be 0, itself or added to any other cell that used A - E respectively during the month. And no each numeric value is chosen based on the amount of time spent on a given day. Kat "M Kan" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
Well, if I select A in A13, and .25 in cell A14, then the total is just .25.
What is the range of cells that will have A through E, and what is the range of the cells that will have the corresponding lenght of time? -- John C "Kat" wrote: A = Annual Meeting B = BOD Meeting C = Contractor Meeting Then the numerical value in the drop down menu below equals the amount of time spent at the meeting. "John C" wrote: In A13, what values do A through E represent? -- John C "Kat" wrote: The value needs to be 0, itself or added to any other cell that used A - E respectively during the month. And no each numeric value is chosen based on the amount of time spent on a given day. Kat "M Kan" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
hope I understood, try:
=A13&A14 in A15 for instance |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
Thanks but that's a no go.
Kat "Jarek Kujawa" wrote: hope I understood, try: =A13&A14 in A15 for instance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
| Cell drop menu | Excel Worksheet Functions | |||
| I need to insert a drop down menu in a cell? | Excel Worksheet Functions | |||
| How to add a drop down menu to a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
