drop down's

G

grizzly6969

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
 
T

T. Valko

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)
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Drop down lists in seperate columns 5
Paragraph numbering in Word 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
multiple drop down menu 3
Problem with SET & REF function 0
date and time 1
VBA Coding Help for Beginner 0

Top