Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions |