SUM conditioned to range
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
|