will this work
Posted by Joseph G. on May 23, 2001 12:20 PM
=SUM(IF(Master!AR3:AR500="'Sector Snapshot!sector_list",IF(Master!AU3:AU500="L",Master!G3:G500)))
basically I have a list of 10 categories that most of a list of securities will fit under. The purpose for this command is to add up the money that is in the "Misc." category.
Assuming that I have listed the 10 categories in the "sector_list" which is located on the sheet "Sector Snapshot"
Will this command work to find anything new that is added to the data file that does not fit into one of the 10 sub categories.
-Joe
Posted by Aladin Akyurek on May 23, 2001 1:07 PM
Joseph
Make of that list a contant array and use the following array-formula:
=SUM((OR(Master!AR3:AR500={"Item1","Item2",...}))*(Master!AU3:AU500="L")*(Master!G3:G500))
Why not give meaningful names to those ranges and substitute the names in their stead?
Aladin
