COUNTIFS & AND + <>

maltaee

Hello,

I appreciate your help in fixing this formula. I want to exclude from counting any blank cell for one column & any cell with "Center" from another column. The one for excluding "Center" is not working.

=COUNTIFS(AND([Deliverable(s)]3:[Deliverable(s)]137, <>"", [Responsible Party]3:[Responsible Party]147, <>"Center"))

Thank you in advance.

Darren Mullen

@maltaee Not the right syntax. Needs range and range criterion pairs. All you have is one AND statement.

Get rid of the AND(). COUNTIFS() will ensure all the criteria are true before counting. COUNTIFS()

Darren Mullen

@maltaee Not the right syntax. Needs range and range criterion pairs. All you have is one AND statement.

Get rid of the AND(). COUNTIFS() will ensure all the criteria are true before counting. COUNTIFS()

maltaee

I removed AND and it is working now. Thank you.

P.S. I tried getting Smartsheet 7 tips but the submission won't get me anywhere or send me the tips.

Darren Mullen

@maltaee Glad that worked for you. Thanks for the heads up about the 7 tips. It should be fixed now.