Put all the diameters in A2 down, all lengths in B1 across, and put the SP
formula in B2

=SUMPRODUCT(--(Sheet1!$A$1:$A$1000=$A2),--($B$A:$B$1000=b$1))

adjust the formula to match your data, then copy down and across

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Serge" wrote in message
...
I have this program created with the help of many smart people in the user
group & many thanks to all that help.
I have a bolt list sheet and a summary sheet with "sumproduct" formulas
that
retreive from the "bolt list" sheet, quantities of different bolt diameter
and length.
But in order for the summary sheet to work, I must input: diameter &
length
in the appropreate cell for a specific grade of bolt.
In other word the, "summary" sheet retreives from the "bolt list" sheet
and
I would like the in formation from "bolt list" sheet send to the "summary"
sheet without any input from the user.
Is this request logicaly possible? If so, would someone guide me in
acheiving this method please.
Many Thanks
Serge