Hi

I have used if statements in a number of worksheets to calculate the total occurances of certain phrases. I now want to Sum the total of these in a different sheet. I have named the first sheet 1 and the last sheet 2 and have tried to use the following =SUM('1:2'!I2) to calculate the total but the result im getting is False. Its a while since I have used excel so am pretty rusty on it.

Thanks