Hi Jeff - Ditto on Laura's comments, but the problem you had does not mean that you have to rename
your sheets:-
Take a look at the two references that follow:-
=Sheet2!A1
='Sheet 2'!A1
The first has no spaces, whereas the second does. The OTHER difference that you should notice is
that the second has a pair of single quotes around the sheet name. This is because of the space,
so as long as you adjust any formulas to take account of that, then a space will not matter.
Pure guess now as I am not sure what is in the rest of your formulas, but the following may do
it:-
=COUNTIF(INDIRECT("'"&F3&"'!"&F4&":"&F5),"P")
There is a single quote between the first pair of double quotes, and a single quote just prior to
the exclamation mark.
