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 spreadshee...
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)