The formula checks cell E2 on a sheet called stats to see if the number
in that cell is between a 15 minute intervals which it gets from a
sheet called Buckets on the same spreadsheet. On this page it has cells
ranging from
C1, C2, C3, C4, and C5 which has numbers in them cells like this:
1:00:00
0:45:00
0:30:00
0:15:00
0:00:00

The cell that contains the formula then places an A, B, C, D, or E in
that cell depending on the results.
I need the formula to only look at the amount of data copy over that
month, which the amount of data will be different each month.

=IF(E2=Buckets!$C$1,"A",IF(E2=Buckets!$C$2,"B",I
F(E2=Buckets!$C$3,"C",IF(E2=Buckets!$C$4,"D",IF( E2=Buckets!$C$5,"E","NA")
))))


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=571898