Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On "Bolt List" Sheet I have as shown below
Qty Dia Grade Flat Washer Length C D E G J _______________________________________________ 6 0.750 A325 Galv 1 1.75 6 .625 A325 Galv 1 2.0 8 .50 A325 Galv 1 2.25 On "Summary Sheet" I have as shown next Dia Length Qty A B C _______________________ In column C I have the following formula =SUMPRODUCT(('Bolt List'!$D$9:$D$188=A19)*('Bolt List'!$J$9:$J$188=B19)*('Bolt List'!$E$9:$E$188="A325 GALV.")*(ISNUMBER('Bolt List'!$G$9:$G$188)) *'Bolt List'!$C$9:$C$188) that will give me the quantities for each diameter and length that are user input in " A" & in "B" Which require the user to constanly check as he populates the "Bolt List" sheet to input the two columns in the "Summary Sheet" This workbook works well as is but I want to eliminate user input on the "Summary Sheet" by having rows from columns 'A' & 'B' populate automatically. Am I asking the impossible? Can someone help PLEASE? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
The { formula } type of formula | Excel Worksheet Functions | |||
How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) |