YOU ARE MY HERO!!!!!!!!!!!! THAT WAS PERFECT.... I WOULD LIKE TO KNOW WHY
BUT AT THIS POINT I'M JUST HAPPY I FOUND SOMETHING THAT WORKED

"Dave Peterson" wrote:

Maybe you could use =sumproduct()

=sumproduct(--('[4DLWEDNESDAY.XLS]9501'!$I2:$U2=$aj$3))
- sumproduct(--('[4DLWEDNESDAY.XLS]9501'!$W2:$AA2=$aj$3))

(Untested)

Tomkat743 wrote:

=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)

--

Dave Peterson