| 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
hope I understood, try:
=A13&A14 in A15 for instance |
|
#4
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 |
|
#5
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 |
|
#6
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 |
|
#7
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 |
|
#8
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 |
|
#9
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
C13:P13+C16:P16+C20:P20 for A-E
C14:P14+C17:P17+C21:P21 for .25-10 "John C" wrote: 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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
This is the formula. Thanks for all your help. :)
=SUMIF($C$13:$P$13,"A",$C$14:$P$14)+SUMIF($C$16:$P $16,"A",$C$17:$P$17)+SUMIF($C$19:$P$19,"A",$C$20:$ P$20) Then B-E respectively. "Peo Sjoblom" wrote: =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 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum from a Drop down menu using value in the cell below
Assuming I understand.
Cell A13, drop down menu for meeting type that you want a tally of total hours for meetings. Cell A14, is total time of meetings (0.25 - 10 each). You have 3 sections that have a meeting type (rows 13, 16, & 20, columns C-P) and the time frame for each meeting is entered just below. This should work, if my assumptions are correct. A14: =SUMIF(C13:P13,A13,C14:P14)+SUMIF(C16:P16,A13,C17: P17)+SUMIF(C20:P20,A13,C21:P21) -- John C "Kat" wrote: C13:P13+C16:P16+C20:P20 for A-E C14:P14+C17:P17+C21:P21 for .25-10 "John C" wrote: 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 |
| 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) | |||
Linear Mode
