How can I SUM a variable number of Rows, where the start and end points will be changing constantly? In the image below I would like to be able to add all the values for each choice together. However there may be rows added in as needed(As you can see Wednesday has more rows than Thursday).
If possible I'd also like to be able to show how many bookings there were for that day using a variation of the below formula:
=CONCATENATE(COUNTA(B2:B13), " Bookings")