if formula maybe?

[tmk0427]

Hi, I'm trying to figure out the best formula to sum each row of cells in D1 and E1 as outlined by the following:

A1 B1 C1 D1 E1
10 10 10 30 30
A2 B2 C2 D2 E2
0 10 0 10 30
A3 B3 C3 D3 E4
10 10 NA 20 20

If any of the cells A1:C1, A2:C2, A3:C3 have max value of 10 or 0 or NA then D1, D2, D3 should sum the values that are greater than zero (the formula I think will work for the D column cells is =sumif(A1:A3,">=0"). However, in E1, E2, E3 I would like a formula that sums the values in the row of cells A1:C1, A2:C2, A3:C3 to include 10 even if there is a 0 value but not include 10 if there is a NA or blank value in of those row cells.

I hope that makes sense.

Thanks.
TK

 

[tmk0427]

What are all the possibilities for C9?

Are you saying we need to allow for C9 being "Y", "N", 1, 0, "NA" or blank?

Yes. Thanks.

 

[tmk0427]

What are all the possibilities for C9?

Are you saying we need to allow for C9 being "Y", "N", 1, 0, "NA" or blank?

Yes all. Thanks.