Hi
I have been using the equation below in the attached worksheet. It accomplishes what I am looking to do: sum lines 00100 to 10099 for each of the companies listed in Column B. I am wondering if the formula can be modified so that it performs the required calculation in the cell next to the company number listed in column K. For example, I would like calculation for company 660074 which is listed in column K, line 2 to be performed cell L2 rather than on the line in column L where the number for the next company begins. In other words, could the formula be modified so that the total for company 660074 occurs in column L, line 2.
[=IF(COUNTIF($B$2:B2,B2)>1,"",SUMPRODUCT(--($B$2:$B$150000=B2),--($D$2:$D$150000>=$H$1),--($D$2:$D$150000<=$I$1),(($E$2:$E$150000="0100")+($E$2:$E$150000="0200")),$F$2:$F$150000))]
Thank you for taking the time to read and consider this request.
Al
Bookmarks