How Can I count Cell On Google Sheet

[Mohamed_Alsabagh]

Hello How Can I Count Cell On Google Sheet
I mean

If

Cell = “ Finshed ” And Cell = “Username”

Then

Count As 1

To Calculate Value

[Bigsykings]

Hello friend if you want share your ai and script code i see maybe help my project

[TimAi2 (metricrat)]

Run a gviz query on the sheet for those values in those columns, then count the number of returns.

This query will return the count for you

"SELECT count(H)  WHERE H contains 'Finished' AND I contains 'basma'"

[deanart2012 (Dean Artis)]

Please don’t be so disrespectful by hijacking other people’s topics.

[Mohamed_Alsabagh]

How Can I put This Number On Label @Still-learning

[Mohamed_Alsabagh]

this my blck

[Mohamed_Alsabagh]

give me error

[Still-learning]

Don’t use for each item list block,

When web got text
Set label text to get response

[Mohamed_Alsabagh]

thanks This Back Text And Number I Need Number Only

[Still-learning]

Try like this, then, it will give you only the result in the label

[Mohamed_Alsabagh]

Thanks Toooo Much It’s Working Good I apricated This