Try this

=SUMPRODUCT((accsPLJ9)*(accsPL<K9)*INDEX(B8:M12,0 ,L9))

with the month number in L9

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Pedro AM" wrote in message
...
Hi All

I need to produce a sum based on a accounts database.
In column A I have accounts from 1000 to 9000 (named accsPL)
In column B to M I have numbers. Each of these columns is one month in the
year.

The formula should sum all values where account number is greater than X
and
lower than Y and return the value in Column headed Z where X,Y and Z are
specified in separate cells.
I thought of:
=SUM(IF((accsPLJ9)*(accsPL<K9),'BD PL'!D8:D12))
My problem is that I want the last part to be moveable as D8:D12 is month
3
and I want it to be the month I specify.
Also, this database is a pivot table so it will grow in length every month
when updated.

Do you guys/girls have any idea on how to overcome this?

Thank you