COUNTIF Issue on Sheet Summary

lucierosenthal

I am trying to see how many times Q1, Q2, Q3, and Q4 appear in my "Quarter" column on my sheet within my sheet summary. I am using the formula =COUNTIF([Quarter:Quarter], "Q1") to try to get just Q1 and it is not working. Any suggestions on why that is not working?

lucierosenthal

Nevermind, I resolved it!

lucierosenthal

Nevermind, I resolved it!

JamesB

Try =COUNTIF([Quarter]:[Quarter],"Q1")

Matt Johnson

Hi @lucierosenthal

Is it counting more than what's there? Could you send over a screen shot and explain what value you are getting and what you expect it to be?

Thanks,

Matt