help with Countif

✭✭✭
edited 08/27/20

Hi I am trying to get a formula working for countif, BACOP Visual Fails, so that it looks at BACOP Serial number and then other fields and it will give me the total number of fails

Answers

• ✭✭✭✭✭✭

Are you able to provide column names and criteria?

• ✭✭✭

HI Paul

below is what i used and i am getting the correct answer but i need it to look at the colum BACOP Serial number also

so i want it to show if something in BACOP Serial number how many fails

=COUNTIF([1. Condition of Paint Work]:[13. Perform cable tug test on all cables], "Fail")

• ✭✭✭✭✭✭

I'm not sure I follow...

Are you trying to count how many rows have "Fail" in the [1. Condition of Paint Work]:[13. Perform cable tug test on all cables] range and is not blank in the [BACOP Serial Number] field?

• ✭✭✭

HI Paul

yes so if something is in the BACOP Serial number field and it failed it will appear, as i need to do the same for BOB Serial number also,

thanks

• ✭✭✭✭✭✭

You are going to need to insert a helper column and use

=COUNTIFS([1. Condition of Paint Work]@row:[13. Perform cable tug test on all cables]@row, "FAIL")

Then you would use a SUMIFS on the helper column and include your requirement of the serial number column not being blank.

• ✭✭✭

Thanks Paul but don't seem to be able to get this to work i have only started to use smartsheets since the start of August so still figuring it out,

in the formula @row do i put in the row number or select the row that i want to be included

thanks

Olivia

• ✭✭✭✭✭✭

Just leave it as is. You should be able to use the formula exactly how it is typed.

• ✭✭✭

Thanks Paul think i got it to work

regards

Olivia

• ✭✭✭✭✭✭

Happy to help. 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!