=CountIF(A:A,"Test")
The formula above will count the number of times the value Test appears in the whole of column A and also display the number.
The formula above will count the number of times the value Test appears in the whole of column A and also display the number.
2 comments:
for countifs formula, what does it look like if i wanted countifs =yesterday's date and countif= name and countif= "active"
for countifs formula, what does it look like if i wanted countifs =yesterday's date and countif= name and countif= "active"
Post a Comment