Quote:
Originally Posted by Spencer101
One way to get the quarterly totals would be to use hidden helper columns. If that's an option, let me know and i'll mock a version up.
If the example workbook is the exact layout you have then it can easily be done using hlookup.
S.
|
Had another look at this and the question to be asked is what version of Excel are you using. If you're using 2007 or later it's easy enough to do, although requires some changing of formats of the date cells.
If using an earlier version of Excel than 2007, it can still be done, but is a little more awkward, especially if you don't have the Analysis Toolpak add in installed.