Simple CountIf

Cat.Cosby

I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?

Kelly Moore

Hey @Cat.Cosby

Try this if you're pulling info from the same sheet. This says count any cell that is not blank

=COUNTIFS([your column]:[your column], <>"")

Use this syntax if the data is in a different sheet

=COUNTIFS({your column with data on the different sheet}, @cell<>"")

remember in a cross sheet formula you must build the cross sheet reference, you cannot simply copy paste the formula into your sheet

Will either of these work for you?

Kelly

Kelly Moore

Hey @Cat.Cosby

Try this if you're pulling info from the same sheet. This says count any cell that is not blank

=COUNTIFS([your column]:[your column], <>"")

Use this syntax if the data is in a different sheet

=COUNTIFS({your column with data on the different sheet}, @cell<>"")

remember in a cross sheet formula you must build the cross sheet reference, you cannot simply copy paste the formula into your sheet

Will either of these work for you?

Kelly

Cat.Cosby

@Kelly Moore Yes this worked! thank you so much!!! I truly appreciate it!