sumproduct would probably do what you want
I do not know what your setup is but
=sumproduct)--(account-number-range = account number),--(currency-range =
currency),value range)
the arrays must be the same size and you cannot use A:A to reference a full
column. A1:A64000 would be OK.


"mishmash" wrote:

Hi,
I'm trying to get a list of balances for different account numbers for
different currencies. Some accounts have different currencies however and so
they need to satisfy the conditions of being both a certain currency and a
certain account number. This is the latest I've got so far, although there
have been different versions as I've tried almost everything:

=SUMIF(('2007'!C4:C2000,'2007'!K4:K2000),("currenc y",'account
#'),'2007'!E4:E2000)

I have tried using nested IF statements also without any luck. Can anyone
help me?