Formula error

[mukeshbaviskar]

Hi friends,
I'm not getting required output in column 'F'.
Conditions:
If both column 'D and E' contains "A" then column 'F' should have a output 'A'
If any of these columns 'D or E' contains value (any number) then column 'F' should have a output of sum ignoring letter 'A' in any of these columns.
Example:
Column 'D' Column 'E' Column 'F'
4+6 = 10
A+6 = 6
6+A = 6
A+A = A
My formula is:

=IF(AND(D8,E8="A"),"A",IF(N(D8)+N(E8)=0,"",N(D8)+N(E8)))

Suggest me a correction.

Thanking you in anticipation.

Regards,

Mukesh

[Richard Buttrey]

Perhaps

=IF(COUNTIF(D1:E1,"A")=2,"A",SUM(D1:E1))

[mukeshbaviskar]

Hi Richard Buttrey,
Thank you. It's working fine.

Regards,

Mukesh

[martindwilson]

alternatively
=IF(A1&B1="AA","A",SUM(A1:B1))

[mukeshbaviskar]

Hi martindwilson,
Thank you for a nice approach. It's working fine.

Regards,

Mukesh