Crating a formula

[Excelnovice13]

I need help creating a formula that will add numbers on a column but will also if the result on that column says auto fail that the sum will be zero

 

[awoohaw]

Welcome to the forum!

What do you mean by "auto fail"?
If you mean if it causes an error, try this:

If you want to sum A2:A10, put this is cell A11

=IFERROR(SUM(A2:A10)0)

otherwise, please give an example.

 

[Excelnovice13]

Welcome to the forum!

What do you mean by "auto fail"?
If you mean if it causes an error, try this:

If you want to sum A2:A10, put this is cell A11

=IFERROR(SUM(A2:A10)0)

otherwise, please give an example.

Hi. So it’s a tool we’re using to audit the team
Each row has a question with a a point system . However some question the response can be autofail. For those responses that are auto fail I need the total to be zero
Example 1
Answer
Row 1. 5
Row2 2
Row 3 10
Total. 17

Example 2
Answer
Row 1. 5
Row 2. Auto fail
Row 3. 10

Total 0


Thanks

 

[awoohaw]

try:

Book1
	A	B	C
1	Q	Q1	Q2
2	Ans1	5	5
3	Ans2	2	Auto Fail
4	Ans3	10	10
5		17	0
Sheet6

Cell Formulas
Range	Formula
C3	C3	="Auto Fail"
B5:C5	B5	=IF(ISNUMBER(MATCH("Auto Fail",B$2:B$4,0)),0,SUM(B$2:B$4))

 

[Excelnovice13]

try:

Book1
	A	B	C
1	Q	Q1	Q2
2	Ans1	5	5
3	Ans2	2	Auto Fail
4	Ans3	10	10
5		17	0
Sheet6

Cell Formulas
Range	Formula
C3	C3	="Auto Fail"
B5:C5	B5	=IF(ISNUMBER(MATCH("Auto Fail",B$2:B$4,0)),0,SUM(B$2:B$4))

Amazing!!! Thank you so much
Enjoy rest of your day

 

[awoohaw]

My pleasure.

Best wishes!