Need help with CountIF formula capturing monthly tags

Nikole K

Hi all, I am simply trying to reference each time the business line is mentioned per month. I think I am close? Month number = helper column calculating month. Legacy PCS = the business line I want to count per month. THANK YOU!

=COUNTIFS({Month number}, "1", [{Business line}, "Legacy PCS"])

Mr. Chris

Hi Nikole,

Give this a shot and let me know if it works for you:

=COUNTIFS({Month number}, 1, {Business line}, "Legacy PCS")

Nikole K

Hi there - I am getting an argument error?

Mr. Chris

The { } brackets from your initial post indicates these columns are being referenced in a separate sheet.

You may have to research the secondary sheet that contains these columns.

Add a test column to the secondary sheet and see if this formula works from there:

=COUNTIFS([Month Number]:[Month Number], 1, [Business Line]:[Business Line], "Legacy PCS")

I was able to replicate the scenario without issues.

See if you can verify these columns in { } brackets are in alignment by clicking

"Reference Another Sheet" from the initial sheet.

Nikole K

hi there sorry it was seemed to not work and then a half dozen tries later we are in business thanks!

Mr. Chris

https://community.smartsheet.com/discussion/comment/421570#Comment_421570

I'm glad this ended up working for you :-)