Adding values from spreadsheet and importing that value into existing workbook

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.
prodatahsAsked:
Who is Participating?
 
Lawrence BarnesConnect With a Mentor Commented:
Attached is a file with one sheet posing as the Master January and the other sheet posing as as the creditor (Fuel Records January).  If you are using separate files you can edit edit the formula to point to a different spreadsheet.
SUMIFExample.xlsx
0
 
Lawrence BarnesCommented:
Sounds like you need the sumifs function.  Do you intend for all of the months to be in different tabs and to add to the formula for each month or have the master sheet have columns for each month?  If it is a low row count (ten thousands per month) then the gas purchase data could all be in one sheet so long as each row has a date on it.

If you upload a sample spreadsheet I can post the formulas directly.
0
 
prodatahsAuthor Commented:
In the master, each month has its own tab.  Each device is on it own row.  I will have worksheets from the creditor for each month as seperate files such as January, february, etc.
The master takes the whole years expenses for each piece of equipment.
0
 
prodatahsAuthor Commented:
That was it exactly.  Thank you for your help!!
0
 
Lawrence BarnesCommented:
Thanks for the points!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.