False result when trying to sum results of IF statements across worksheets

**mark.studley** · 05-13-2013, 10:20 AM

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

**Fotis1991** · 05-13-2013, 10:25 AM

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

**Fotis1991** · 05-13-2013, 10:26 AM

Do you have any #N/A value in any of your sheets I2? Perhaps a I2 to be TEXT that looks like number?

Formula should works..

**mark.studley** · 05-13-2013, 10:30 AM

I went through and noticed that one of the sheets was filtered so I2 was hidden, this was causing the problem as when i unfiltered it it worked. Thanks for the help, sorry for an unecessary thread.