Which formula do I use?
I used the following formula =COUNTIFS({Imp Group},Label@row, [{IT Sizing}, [IT Sizing]1) for the table data below. I keep getting unparseable. What am I doing wrong?
Source Column Title for Rows Day 0, Day 1 & Day 2 is "Imp Group".
Source Column for title is "IT Sizing"
Best Answers

@toni.toni601 I think the square bracket in front of the first {IT Sizing} is out of place or not needed at all.
dm

@toni.toni601 You removed the range for the second condition, so you have nothing to match against the second criterion. I think you need:
=COUNTIFS({Imp Group}, Label@row, {IT Sizing}, [IT Sizing]1)
dm
Answers

@toni.toni601 I think the square bracket in front of the first {IT Sizing} is out of place or not needed at all.
dm

Thanks for your help
I changed to =COUNTIFS({Imp Group}, Label@row, [IT Sizing]1) and how get error message #incorrect argument set. What is it looking for?
also... Is this the best formula to use?

@toni.toni601 You removed the range for the second condition, so you have nothing to match against the second criterion. I think you need:
=COUNTIFS({Imp Group}, Label@row, {IT Sizing}, [IT Sizing]1)
dm

GREAT!!! I changed to: =COUNTIFS({Imp Group}, Label@row, {IT Sizing}, [IT Sizing]1)
Worked PERFECT!! thank you so much...
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!