Hi all,
I have the following issue and I was wondering if someone out there could help me on this.
Imagine that you have an Excel spreadsheet that has 19 tabs (sheet1, sheet2, etc right through to 19) and then one final tab named summary.
Sheet1 - 19 containes mobile phone data with column a stating the type of call e.g. national, premium rate, international, etc and column b the cost.
In the summary section I want to sum up these headings from Sheet1 - 19, however there is a slight issue in that if I want to sum up the totals for International, there are various headers for this i.e. International - Zone 1, International - Zone 2 etc up to zone 10. In the summary section all I want is to name this part "International Calls".
I guess I need to combine a 'sumif' statement with a 'left' but having not much luck with this.
Is there any way this could be done using a simple formula?
Your help is very much appreicated.
2007-06-24
21:29:27
·
7 answers
·
asked by
No1DiamondGeezer
1