I am trying to track how many times volunteers attend a meeting. I have a sheet with a row for each volunteer. One column in number of times they've attended a meeting. The values in the column range from blank to 15. I created a new sheet for metrics, eventually I'd like to make this into a graph, I made the first column all the numbers 1-20. The second column I added the formula;
=COUNTIF({Member Involvement and Skills Meeting Points}, CONTAINS(points@row, @cell))
note: "Member Involvement and Skills" is the sheet I referenced and I choose the column that has the number of meetings each person attended.
After contains I clicked the first cell in the column with numbers 1-20 and then did , @cell.
I then selected the cell with the above formula and used the + in the bottom right corner of the cell to copy the formula all the way down to row 20.
Every result fills in 0 even though we have people with 1, 2, 3, 6 etc….
I went back to an old metrics sheet that I have that works correctly and the only difference I can find is that the reference to the cell with value we're looking if it contains has [ ] around it. I tried adding that and it didn't work either.
help!!!
