imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
I have a table containing information about a series of companies. The company numbers are in column 1. I have reporting dates in column 2. In column 3 and 4 are planned and actual numbers. I want to report the month to date totals for each of the companies. The table is sorted based on company number then by date. I tried sumif but was unable to determine how to drive the argument for the date range. Also, I only want to sum relevant cells based on meeting the criteria of current month and company number. Anyone have a suggestion?