CountIf AND

ShawnM

Hi I am trying to write a CountIF AND Formula for Chart

Countif.PNG

The Column choices are Case Carrying vs NonCase Carrying

The rows are Region 1 to Region 6

So for example: Countif the person is in Region 1 AND is Case Carrying. I keep on getting different errors.

Thank you for your help!

Antonie B

@ShawnM -

For a count with multiple criteria, I would recommend a COUNTIFS formula: https://help.smartsheet.com/function/countifs

You can also take it a step further and make it dynamic using @row for the regions! (https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell)

Example of the formula would be: =COUNTIFS(Region:Region, Region@row, Case:Case, "Case Carrying")

I would amend the formula column references to line up with your column names, but hope this helps!

Antonie B

@ShawnM -

For a count with multiple criteria, I would recommend a COUNTIFS formula: https://help.smartsheet.com/function/countifs

You can also take it a step further and make it dynamic using @row for the regions! (https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell)

Example of the formula would be: =COUNTIFS(Region:Region, Region@row, Case:Case, "Case Carrying")

I would amend the formula column references to line up with your column names, but hope this helps!

ShawnM

Thank you Antonie for taking time to answer my question! I will give this a try!