Help with SUM for calendar salary fields

[liquidjade]

Hi all, I have a calendar for my band set up in excel 2010. What I'd like to do is have all pay from each different venue added up for the month and for the year. Being a calendar I only have the venue name, time and pay listed in the day's box. Is there a formula to select all the fields with 'Hilton' and add those up? Or, if someone has a better layout I'd be open to that as well.
I think I attached a sample xls.
Thanks for any thoughts
Jeff