Hi,
I am making a spreadsheet to track fuel costs from 3 vendors, and I want to calculate the average price per litre for each vendor, for each month.
I have 2 worksheets: (1) Data Entry, and (2) AVG PPL
Data will be entered in the Data Entry worksheet as follows:
Column A: Vendor name
Column B: Period (i.e.: Sept. 2010)
Column C: The price per litre.
I want to calculate the average price per litre on the "AVG PPL" worksheet based on the data inputted into the "Data Entry" worksheet.
For example: in cell B2 in the "AVG PPL" worksheet I want to calculate the average price per litre for all entries in the "Data Entry" worksheet that match Vendor A, and the period Sept. 2009.
My problem is that I don't know what formula to use in cell B2 to calculate this average. I thought it would look something like this:
=average(if(and('Data Entry'!$A$A="Vendor A",'Data Entry'!$B$B="Sept 2009")'Data Entry'!$C$C))
but this doesn't work.
A copy of the spreadsheet is attached.
Please help.
Thanks
Bookmarks