Hello. Is there an expression for COUNT IF in...

expressions
(Andrea Sala) #1

Hello. Is there an expression for COUNT IF in Appsheet?

(Aleksi Alkio) #2

Not directly but when you use SELECT with criteria, it’s the same than Count IF… sort of. For example COUNT(SELECT(Table[Column],[Column]=“Value”)). This will count all records where the column is “Value”.

(Andrea Sala) #3

Thanks I’ll try it and let you know

(Tony Fader) #4

@Andrea_Sala https://www.appsheet.com/samples/This-app-shows-how-to-do-SUMIFs-and-COUNTIFs-in-AppSheet?appGuidString=22f56e42-2079-4ef5-8780-22c469762700

(Andrea Sala) #5

@Aleksi_Alkio. It works Perfect, thanks a lot. +Tony Fader. Thank you too

(Aleksi Alkio) #6

You’re welcome