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

[Andrea_Sala]

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

[Aleksi_Alkio]

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]

Thanks I’ll try it and let you know

[tony1]

@Andrea_Sala https://www.appsheet.com/samples/This-app-shows-how-to-do-SUMIFs-and-COUNTIFs-in-AppSheet?appGuidStr...

[Andrea_Sala]

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

[Aleksi_Alkio]

You’re welcome

[fnland]

hello @Aleksi , i am from Indonesia sorry if my english is wrong,
i use the COUNTIF formula in my excel like =COUNTIF($F$2:F2;F2)
how i can do that in appsheet? thank U

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I do SUMIF() or SUMIFS()? SUM( SELECT( Orders[Total Amount], AND( ([Customer] = [_THISROW].[Customer]), ([Order Date] >= [_THISROW].[Order Date]) ) ) ) Use SELECT() to gather values from a single column only. See also: AND(), SUM()