LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default What type of formula?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
How to type correctly formula in calculated field in a pivot? louloutte48 Excel Worksheet Functions 2 June 28th 05 01:46 PM
The { formula } type of formula Alex Excel Worksheet Functions 7 June 17th 05 09:06 PM
How to I use ** without Excel thinking I want to type a formula? Buff Excel Discussion (Misc queries) 2 December 22nd 04 09:31 PM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"