Count the number of requests submited

Roshni Verappan

I have a tracker that that is used to capture Recording Requests. there is a column that has Number of recording required and that could be 1 - 3 that can be selected from a drop down. So if a user selects say 2 recordings are required. I would like to have a total column that shows how many recordings are being requested right away.

Formula I tried was :

=COUNTIF([Number of Voice Recordings Req'd]@row, "1"), AND([Number of Voice Recordings Req'd]@row, "2")

I am sure there is a better way to get the total number requested?

thank you

Paul Newcome

My suggestion would be to use a helper column that converts the selection into a numerical value.

=VALUE([Number Selection Column Name]@row)

Then you can just

=SUM([Helper Column]:[Helper Column])

Paul Newcome

My suggestion would be to use a helper column that converts the selection into a numerical value.

=VALUE([Number Selection Column Name]@row)

Then you can just

=SUM([Helper Column]:[Helper Column])

Roshni Verappan

Thank you that worked perfectly.

Paul Newcome

Happy to help. 👍️