COUNT IF hi, i'm building an app for the in...

expressions
(Mark Pathfinder) #1

COUNT IF

hi,

i’m building an app for the invoices, and i need to count the issues invoices.

I’ve 2 column: ISSUED : YES/NOT INVOICE N° : where i must insert the formula

i checked https://help.appsheet.com/expressions/functions/count but i didn’t find the solution.

How can i do?

(Steven Coile) #2

What have you tried?

(Mark Pathfinder) #3

COUNT(LIST and COUNT(SELECT

(Aleksi Alkio) #4

You can do that like COUNT(SELECT(TableName[KeyColumn],[ISSUED]=“Yes”))

(Mark Pathfinder) #5

Tx Aleksi for your support, i tried also COUNT(SELECT(TableName[KeyColumn], IN([ISSUED], {“Yes”}) and it also works