Which formula do I use?

toni.toni601

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

@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

@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

Dale Murphy

@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

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?

Dale Murphy

@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

toni.toni601

GREAT!!! I changed to: =COUNTIFS({Imp Group}, Label@row, {IT Sizing}, [IT Sizing]1) 

Worked PERFECT!! thank you so much...