I have to track gas usage using an excel 2007 workbook. In the master workbook i have each piece of equipment and a gas card number for that specific piece of equipment in one row. I download the expenses for the month from our creditor (in excel format) that has the same gas card number as in my workbook however, they are in no specific order. I want to rename the spreadsheet from the creditor to the month that it pertains to (i.e. January) and import the data into the master workbook. The creditor doesnt add all the expeditures for each gas card. It has each purchase on an individual row. I would like to use a formula in a cell in the master workbook that looks in January for the gas card number in column A and adds all the values it finds that are in column D together for that specific card.