Thanks for bothering...

The formula sums all the AMOUNTs oi rows where PERIOD equals "2006-08" and
ACCOUNT is not null.

I would like to put "ACCOUNT" in cell $A$2 and put the cell reference $A$2
in the formula instead.

BR


"daddylonglegs" skrev:

Don't really see how this works

=SUMPRODUCT((ACCOUNT)*(AMOUNT)*(Period="2006-08"))

this will multiply the account number(s) by the amount(s)

If you are summing Amounts for a specific account number that would be
something like

=SUMPRODUCT((ACCOUNT=3220)*(AMOUNT)*(Period="2006-08"))

What do you have in A2 - a specific account number?




"MIKWIN" wrote:

Formula:
SUMPRODUCT((ACCOUNT)*(AMOUNT)*(Period="2006-08"))
works fine... it sums the amounts where period equak 2006-08

but

Forumla:
SUMPRODUCT(($A$2)*(AMOUNT)*(Period="2006-08"))
doesn't work...

$A$2="ACCOUNT"

ACCOUNT=(A2:A65535)

Data table
Account Amount Period
7830 23400 2006-08
3220 -99900 2006-12
3440 -7100 2006-08
3560 2700 2006-08
8540 7900 2006-12

Is there anyone that could help, plse

Best Regards