Hi
I have been working on analyzing the performance of a group of organizations. As you will note from the attached worksheet, I have used the equation =SUMPRODUCT(--($D$2:$D$150000>=H1),--($D$2:$D$150000<=I1),(($E$2:$E$150000 ="0100")+($E$2:$E$150000 ="0200")), $F$2:$F$150000) to identify the total for all organizations reporting expenses on, for example, line 00100-00149, column 0100 and 0200. I would like to modify the equation to select the 00100-00149, column 100 and 200 values for a specific organization. It seems to me that I have to add an additional identifier (org #) to get this value.
Thanks for your help.
Al
Bookmarks