In my spreadsheet I have multiple worksheets. On one worksheet are a listing of trades in a futures contract including Date, Time, Price, etc. The times are imported from a .csv with time data in 8:00 format, displayed in the formula bar as 8:00:00 AM and formatted to 8:00. There are about 625 of them, with same and different times by date, depending on when the trade triggered.

On another spreadsheet I have rows for each minute of the open and close time frames (9:30, 9:31, 9:32, ...). In each cell under that row is the formula: {Sum(If(TTime = "cell above", Ticks,0))} where TTime is the Named Range for the trade times and Ticks is the Profit/Loss. I can look in the Data woksheet and see trades for 9:45, for instance, but the formula in the cell under the 9:45 time on worksheet 2 returns 0.

If I look in Name Manager at the values, there are no values for 9:45 listed even though they are there. The Range defined for TTime is correct (D6:D628) and encompasses all trade times.

Can someone help?