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?