=COUNTIF('[4DLWEDNESDAY.XLS]9501'!$I2:$U2,$AJ$3)-COUNTIF('[4DLWEDNESDAY.XLS]9501'!$W2:$AA2,$AJ$3)
I WOULD USE AN ARRAY FORMULA OF =COUNT(IF((
BUT THE CELLS I'M TRYING TO ENTER THE FORMULA INTO ARE MERGED CELLS AND
WILL NOT TAKE AN ARRAY FORMULA.
$AJ$3 COULD ALSO BE TEXT IE: "2M" "3C" "2A" (NOT CELL REFERENCES JUST
BILLING CODES)
Bookmarks