Alehm:
I can only guess that your 22709838 carrier number is entered as text.
Try enclosing the number in quotation marks ("22709838") in your
formula. By the way, if you are entering the quotes, then your number
is NOT text, therefore, remove the quotations marks.
A better option may be that you use a cell reference rather than the
exact entry. e.g.
=SUMPRODUCT((A2:A13<"")*(B2:B13=*_B2_*)/COUNTIF(A2:A13,A2:A13&""))
where *_B2_* holds the carrier information.
Either should solve your problem.
Good Luck
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=465946