help with Countif

Olivia Brady

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

Paul Newcome

Are you able to provide column names and criteria?

Olivia Brady

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")

Paul Newcome

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?

Olivia Brady

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

Paul Newcome

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.

Olivia Brady

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

Paul Newcome

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

Olivia Brady

Thanks Paul think i got it to work

regards

Olivia

Paul Newcome

Happy to help. 👍️