Can explain y must I insert the asterisk as the purpose of trim is to remove
space char. ?

"davidm" wrote in
message ...

Modify Gord's formula to:


SUMIF(trim(A:A),"AR*",B:B)


(note the use of the asterisk)


David


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=488061