Sumif for two criteria

[skatmandu2002]

Hiya,

I've come across a problem that I'm sure I would normally be able to solve. I'm sure it's really simple too, but I think I'm being quite stupid today...

I need a formula that checks if there are any cases where both cells in column A2:A12 say "Ukn." and B2:B12 say "YES".

Thanks

[davesexcel]

Try Sumproduct,

=SUMPRODUCT((A1:A10="Ukn.")*(B1:B10="YES"))

More info on sumproduct here