sum if

[kieran]

i'm using the sum if function to sum amounts in a column
based on the values entered in another column. e.g sum by
currency. How do I use sumif where I want to consider the
values in two columns. e.g sum col G if col A is USD and
Col B is xxx or yyy.

Many thanks

 

[Frank Kabel]

Hi
use
=SUMPRODUCT(--(A1:A100="USD"),--(B1:B100="xxx"),G1:G100)

See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html