Modify Equation

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

Just add a place to input the organization (e.g., G3) and this code right after SUMPRODUCT(

--($B$3:$B$150001=G3),

Hi

Thanks for a quick response. I modified the equation successfully (I think) and it worked for the first iteration. As you will note from the attached worksheet, when I tried it on the second company it failed to return a value which is located at F100. I must have left something out?

Thanks for your help.

Al

It's because G3 is text, not a value. Format it to, say General, and it works fine.

Just a note to say thanks.

Al