Forum Discussion
How to calculate sums for locations
Hi everyone,
I have a spreadsheet that I am using to calculate the locations guests came from for events. The problem I am having is figuring out how to make a formula that allows the spreadsheet to count the number of people that registered by location.
For example, if in the column labelled location it says "Toronto" and in the column labelled Attendee Number it says "2" it would count it as 2 people from Toronto attended. If there was more than one "Toronto" in location, it would add all the attendee numbers together to create a sum total of attendees that listed their location as from Toronto.
Does anyone know how I can go about doing this?
Thank you!
1 Reply
One option is to create a pivot table based on the data.
Another is to use the SUMIF function:
=SUMIF(location_range, specific_location, attendance_range)
