Morning all

I thought the following would be quite simple but I am having trouble with
it. Only the first part of the forumla appears to be working (if g4 = all
then the value I want comes up), howerver if I enter any of the others I get
''FALSE'' appear

Any ideas?

Also if anyone can additionally help me I need to add 1 more IF to this
forumla but it wont let me as I would then have more than 7 functions. So
would anyone have an idea how to reduce this forumla ?

Thanks in advance

=IF(G4="All",COUNT('NA Actuals & Base Info 2009 $'!C3:C36,'EU Actuals & Base
info 2009 ‚¬'!C9:C48,'EU Actuals & Base info 2009
‚¬'!C59:C73,IF(G4="London",COUNT('EU Actuals & Base info 2009
‚¬'!C22:C48,IF(G4="Stuttgart",COUNT('EU Actuals & Base info 2009
‚¬'!C59:C73,IF(G4="Geneva",COUNT('EU Actuals & Base info 2009 ‚¬'!C9:C21))))))))