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?
Bookmarks