Cross sheet formula - help
With this new feature I'm hoping I can eliminate abut 10 columns from one sheet and create a sheet just for totals.
Currently I have several columns just for counting the value of columns with checkboxes. Do I have to leave these in the same sheet? When I tried to do the values in a new sheet by referencing the main sheet it didn't work.
Also, I had ended up creating checkbox columns for several locations (check-in boxes) but since I have a dropdown column for the locations is there a way to have one check in column on the main sheet and use a formula to count the checkbox column using the specified criteria from the location column?
I've watched several videos over and over and while it seemed it should work it didn't.