excel calculations

[lloyd8156]

i need to do a large number of calculations based on a worksheet with the
results displayed in another sheet. the calculations are like if size=225 and
pattern=xca and miles>0 sum the qty and sum the miles. i am using the wizard
to do this but i have about 2000 to do and i cant manually type each one can
anyone help???

 

[dfeld71]

you need to be more specific. Provide an example of what each
spreadsheet looks like, and what exactly you are trying to bring back