Invoice Tracking

**Arnoldleg** · 08-26-2009, 12:10 PM

Apologies if this is simple

I have a spreadsheet with columns containing:

Invoice No
Date of Invoice (by months)
Value of invoice

I would like to be able extract invoice values for specific months and place in a table with months along the top so I can establish out of all the invoices, how much will be going out each month, ie, extracy the values for say, March and find the total

Thanks in advance!!!

**Palmetto** · 08-26-2009, 12:32 PM

Take a look at using a Pivot Table - it is designed to allow analysis of such data and permits grouping by days, weeks, months, years, etc.

If that is not an option, you should post a sample workbook that shows the desired results.

**Arnoldleg** · 08-27-2009, 10:03 AM

Thanks Palmetto
I think that may do the job - I'll give it a go and get back to you with any issues. - Thanks again
Arnold

**Arnoldleg** · 08-27-2009, 01:09 PM

Palmetto
I've failed - am going round in circles and am probably being incredibly stupid!
I've attached a sample file below.
If you look at the tab named 'Schedule', you'll see what I'm tring to populate.
The problem I had with pivot tables was the dates due to how the data is inputted on each consultant's page.
Anything you can suggest would be grately appreciated
Many Thanks
Arnold

**Palmetto** · 08-27-2009, 01:32 PM

On the Schedule Sheet, C7 and copied across.

=SUMPRODUCT((Planning!$C$22:$D$48>=C$6)*(Planning!$C$22:$D$48<=D$6)*(Planning!$C$22:$C$48))

Cell C8 and copied across.
=SUMPRODUCT((Architect!$C$22:$D$48>=C$6)*(Architect!$C$22:$D$48<=D$6)*(Architect!$C$22:$C$48))

Copy the formula down column C and adjust the sheet reference, the copy it across the row. This will work as long as your sheet structure is the same for all of the sheets, whichit seems to be.

**Arnoldleg** · 08-27-2009, 01:50 PM

Palmetto
That's great!
Thank you very much for the prompt response - looking at your formula, I don't think I ever would've got there.
Thanks again
Arnold

**Palmetto** · 08-27-2009, 01:57 PM

You're most welcome.

If you're satisfied with the solution please mark the thread as solved and remember to rate the response.

**Arnoldleg** · 08-27-2009, 02:13 PM

Apologies
The response was excellent and very fast too!
Hopefully I've done the things to mark it as such (I even had to look up how to do that!!)
Cheers
Arnold