Countif formula help. All the answers come back zero when I know they are not.

Beth Ware

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!!!

Paul Newcome

Points@row.

=COUNTIF({Range}, Points@row)

Paul Newcome

How are the meeting points populated in the source sheet? Are you able to provide some screenshots for context?

Beth Ware

They were entered in manually.

Paul Newcome

In that case, try it without the CONTAINS function.

Beth Ware

So I'm telling it to countif, referencing the sheet and column I want it to get the information from, and then how am I telling it what to look for? count if what?

I've used the formula before and it's worked perfect. That's what is making it frustrating.

Paul Newcome

Points@row.

=COUNTIF({Range}, Points@row)

Beth Ware

Paul, thanks much. That worked. Not sure I'm understanding the why, but I got what I needed. Appreciate the help