Formula needed please

[chimp]

i am trying to finalize my spreadsheet but am having a little troubl
with one of the formulae;

i am trying to sum the total revenue depending on the car type, an
garage which sold the cars.

on my attachment you will see a column called revenue:

i need this column to contain the calculation.

i need it to work in a similar way to the

reference in cell h5
=SUMPRODUCT((SALES!$B$6:$B$500=\"GLASGOW\")*(SALES!$F$6:$F$500=$B5)*(SALES!$H$6:$H$500=1)

but only this time i need a total amount for each car sold.

the reason i need this is that the salesman may wish to sell a car fo
more/less than the recommended selling price.

please help

Andy

attachmant found here:

ZIP VERSIO

'Zipped Version
(http://members.lycos.co.uk/redtilefc/College/Copy of Test1.zip

 

[Don Guillett]

I looked at your example and the problem appears to be coming from your
sales!column H and the dates referred to in column A.