SUM with COUNTIF or not?

[ivanbas]

Hello guys, I am struggling for hours with this and can't get it right, plase help

If supplier is from one country, China, I need to sum all amount from column M. If it is not, I need to write that there was no supply outside Europe.

=SUMIF(D2:D10,"China",M2:M10)

With this function I managed to get correct quantity, but if I add this:

=SUMIF(D2:D10,"China",M2:M10, ''no import outside EU'')

I get an error. My logic must be wrong then, should I use COUNTIF first and then SUM maybe?

 

[jtakw]

You're welcome.

The COUNTIF will produce a number as a result, anything that's Not a Zero will evaluate as TRUE, if the Count is Zero, it will be evaluated as FALSE.