Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down's
I have in A1 a drop down menu that displays line 1 through line 9
and in B1 drop down menu monday through Friday is it possible to for example click on line 1 and click on Tuesday and in C1 display how many parts were made that day. On a seperate work sheet I have each line and each day and how many parts were made each day -- grizz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down's
Try this:
Sheet2 column A = lines (???) Sheet2 column B = weekdays Sheet2 column C = production numbers Enter this formula on Sheet1 C1: =SUMPRODUCT(--(Sheet2!A1:A10=A1),--(Sheet2!B1:B10=B1),Sheet2!C1:C10) -- Biff Microsoft Excel MVP "grizzly6969" wrote in message ... I have in A1 a drop down menu that displays line 1 through line 9 and in B1 drop down menu monday through Friday is it possible to for example click on line 1 and click on Tuesday and in C1 display how many parts were made that day. On a seperate work sheet I have each line and each day and how many parts were made each day -- grizz |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down's
Hi,
In C1 try this =SUMPRODUCT(--(Sheet3!A$2:A$367=A1),--(TEXT(Sheet3!B$2:B$367,"DDDD")=B1),Sheet3!C2:C367) In this case the Line #'s are in the range A2:A367, the dates as dates are in B2:B357 and the amounts are in column C. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "grizzly6969" wrote: I have in A1 a drop down menu that displays line 1 through line 9 and in B1 drop down menu monday through Friday is it possible to for example click on line 1 and click on Tuesday and in C1 display how many parts were made that day. On a seperate work sheet I have each line and each day and how many parts were made each day -- grizz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |