Error in SELECT function

[Oldsoul]

Hi, everyone.

I have no idea where my error is in this formula, i need to count the amount of people that needs to change gloves in the current month, so i’m following the method of this article, SUMIF and COUNTIF

i created a virtual column named “Vencidos” like in the example “Selected Quantities”, therefore i cant put that virtual column ina COUNT() formula. but this error happens.

[Marc_Dillon · Accepted solution]

It’s your first argument, it can’t just be a column. Generally it is Table[Column].

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Oldsoul]

That was the problem, thank you.