C
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
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