If Statement

[jassa]

Hi All,

I have an If Statement that searches for 2 elements.

Formulae: =COUNTIFS(AB!J:J,"LOCAL",AB!R:R,"U")

In column J it looks for the Letters Local

In Column RR it looks for The letter U.

I would like to add another Statement that says if 'No' Is found in column S it should calculate this as a number.

If you can let me know how i can alter the present formulae to add the 3 criteria,

Many Thanks

 

[AlanY]

wouldn't be just?

=COUNTIFS(AB!J:J,"LOCAL",AB!R:R,"U",AB!S:S,"No")

 

[jassa]

Thank Alan, not sure why i couldnt figure out why i just didnt add a comma and type it again. One of my moments.

Do you know how i can get S:S to pick up everything but No?

 

[AlanY]

you're welcome.

for everything but No, use "<>No" instead, i.e.

=COUNTIFS(AB!J:J,"LOCAL",AB!R:R,"U",AB!S:S,"<>No")