Counting cells that have specific value

[al7abob]

Hi there,

Im working on a grid table where I have a table with data .. I want to count the cells that have specific value example "DONE"

Similar to function "COUNTIF" In Excel .. I have searched alot in the forum but couldn't find any

Waiting for your reply

[daviz]

Have you tried with a for loop?

David Ramirez

[al7abob]

Im a biginner .. no idea how to use for loop and count the cells

[daviz]

can you share your project?

David Ramirez

[al7abob]

Sorry for my late reply,

The grid imports the data from Excel CSV file
then I want to check each cell in column 4 (completed date) .. if there is a date then count it
then replace the total count in label

1) For now have included
Grid.LoadFromFile("Grid1", "AutoPlay\\Docs\\1 NON.csv", ",", true);

in page>on show

2) I know how to replace the count in label but i dont know how to count the cells that have completed date in column 5

[charliechaps]

OK I've done an example for you, it loops thru the Grid rows checks if text in cell if so adds 1 to the count
CSV GETCount.apz

It's Basic so you get the idea

[al7abob]

Works perfectly.. Appreciated