Dynamic name reference in SUMPRODUCT
Try
Indirect($A$2)
"MIKWIN" wrote:
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
|