Count formula results are off by 1

Randy Van Winkle

I build a simple formula to count results in a column

=COUNT(Status:Status, "Open/Active")

When i fist made the formula it should have reported 4 but it said 5. I made sure that nothing was hidden or had white on white text and even deleted all the rows out . When all rows were deleted out the formula returned value of 1

Mike Wilday

Cool, thanks for catching that. I just edited it. Can you mark it as the correct answer! Thanks. Glad I could be of help.

Mike Wilday

Try using =Countif(Status:Status, "Open/Active")

Mike Wilday

Can you send a screenshot of test data that mimics what you have setup? That will help as well.

Randy Van Winkle

You had a period instead of a comma after Status, but otherwise it worked

Mike Wilday

Cool, thanks for catching that. I just edited it. Can you mark it as the correct answer! Thanks. Glad I could be of help.

Randy Van Winkle

Done! thanks