Formula Question

Graham Cracker

Need to create a formula that counts all rows containing the phrase "On Site"

Amit Wadhwani

Hi @Graham Cracker

Assuming that your column name is "Work", use the formula below in a summary field. You need to replace Work:Work with your column name for this to work.

=COUNTIF(Work:Work, "On Site")

Amit Wadhwani

Hi @Graham Cracker

Assuming that your column name is "Work", use the formula below in a summary field. You need to replace Work:Work with your column name for this to work.

=COUNTIF(Work:Work, "On Site")

Graham Cracker

Thank-you Amit! That worked!