Hi,
Can you please tell me how to put a symbol on a line, if a time is before or
after a specified time. I have tried the following which is a valid formula,
but does not give me the correct answer.

=IF(AND("06:00:00"<C1575,C1575"18:00:00"),5,3) (the relevant field is
formatted to monotype sorts to give either a tick or a cross)

I am also trying to produce an IF formula that looks at a block of cells, I
have tried the following, which only works for the first cell in the block

=SUMIF(E10:E1600,E1609:E1615,(K10:K1600))

The E1609:E1615 contains text names

Any help would be really appreciated, thanks

Joco (London)