darkwolf666
Well-known member
Can find my way round Excel for the most part, at an intermediate level, but am currently stumped by a dilemma.
I have a spreadsheet that has multiple worksheets on, each for a different financial account - what I would like to know is there a way to find a total value for all the accounts from each different spreadsheet combined, on a set date?
Just to further add confusion though, each account doesn't have an entry for every day - so I am guessing some sort of date range would need to be applied!
Any help greatfully received.
I have a spreadsheet that has multiple worksheets on, each for a different financial account - what I would like to know is there a way to find a total value for all the accounts from each different spreadsheet combined, on a set date?
Just to further add confusion though, each account doesn't have an entry for every day - so I am guessing some sort of date range would need to be applied!
Any help greatfully received.