Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula for monthly tracking?
I have worksheets that represent different vendors. I need to be able to pull
monthly numbers out of worksheets and keep track of them. Here's the problem. The invoices don't get put in to the worksheets in chronological order. There may be 5 invoices in a row for the month of January then 4 after that from February then maybe 2 after that from January. Is there a way to have Excel scan the date columns and add up the ones that are the same month and then put that total in another column? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking portions of a formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |