Need help in summary formula

[vsravi.kmb]

Need help in formula in column N in the attached file. Please help.

[Ace_XL]

In N21

=IF(M21="","",SUM(M$7:M21))

This can the be copied and pasted in any Cell in Col N

[vsravi.kmb]

In N21

=SUM(M$7:M21)

This can the be copied and pasted in any Cell in Col N

Thanks for the quick reply. It works fine. But when I drag down the value appears on all the rows. I need the value to be appeared only once for the first entry of the day like summary in row 7, 21 like that.