Creating an auto subtotal

[Pickygame]

Hi

I am trying to create a way of subtotaling a selection range of figures that varies each day. On one day i may only have i entry but other days i can have more. I would like users to enter the separate amounts and then get a daily total. I have attached a sample spreadsheet

Thanks

[Olly]

In C2, enter:

Please Login or Register  to view this content.

and copy down.

[Pickygame]

Thank you. Greatly appreciated. What does <> achieve by the way because i see it a lot

[Olly]

<> means 'is not equal to'

Glad you're sorted.