Monitor Your Team’s Contributions Using a Spreadsheet

In the last article, I am already discussed about the COUNTIF formula. So this article, I’d like to revisit that topic. Here’s the case we want to address.

The Case

I have a task to record, specifically to monitor cash payments in my class. This recording involves 10 students. As the treasurer, I tried to solve it using a spreadsheet.

I had various ways of solving it, starting from manual calculations, which of course took a long time.

The Solutions

Actually, based on my previous article about the COUNTIF formula, I could calculate it by recording ‘V’. However, with a spreadsheet, we can make it cooler by creating a checklist, enhancing the appearance of the sheet. Let me show you how.

First, select a cell where you want to add “V” so that it becomes active (C4).

Next, select the insert button > checkbox, like this (Still C4).

See, now the checkbox has appeared.

Simply drag and drop to spread the checkboxes to all students.

Now it’s time to do the calculation. In the Total column, let’s play with the COUNTIF formula we used earlier.

Do you know why I chose TRUE? Because the checkbox represents a Boolean value, where if it’s checked, the value is true. That’s how we utilize it.

Conclusion

In this article, I’ve explained how to monitor cash payments using a spreadsheet. My hope is that this article can be useful to anyone who needs it. Thank you for reading.