Which formula do I use?

Question

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"

Dale Murphy · Accepted Answer

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

dm

Dale Murphy · Accepted Answer

@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