Formula not working after copying and pasting it to another sheet

**excelgirl250** · 04-07-2011, 03:40 AM

Hello,

I'm new to this site, and I really need help with my excel work. I have been figuring out whats wrong, but I could not figure it out.

I am trying to count the number of visitors per hour, and I copied the formula from an old file, but when i paste it to a new file, it's not giving me the correct result, but just giving me zeros. Here's the formula:

=SUM(IF('Prep Data'!$B$2:$B$2200="Tuesday",IF('Prep Data'!$C$2:$C$2200>=9,IF('Prep Data'!$C$2:$C$2200<10,1,0),0),0))

Here's the sample of the raw data:
A B C D E
ID DAY Sign In Sign Out Total Time
64135 Monday 8.86 9.05 -0.19
764775 Monday 9.54 11.37 -1.83

I hope you can help me figure out how to make this formula work so I can count the number of visitors per hour.

Thanks

**batman07** · 04-07-2011, 03:52 AM

Could you please upload a sample of your new excel file.

**Domski** · 04-07-2011, 03:52 AM

Have you confirmed it with Ctrl+Shift+Enter rather than just Enter as it's an array function?

Dom

**excelgirl250** · 04-07-2011, 11:16 AM

Thanks for the reply. I tried the CTRL+SHIFT+ENTER, but still it doesnt work.

Do you recommend any formula I can use to count the number of visitors per hour base on the raw data sch as, visitor ID, sign in time, sign out time, date?

Thanks!