Your welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"HaSt2307" wrote in message
...
Biff,
Yes they are in text strings i.e. 300 - Misc Income and your solution
also works. I will have to also file this one away for later use.

Harry


T. Valko wrote:
If these are alpha-numeric codes that are actually text strings:

=SUM(SUMIF(B4:B14,{"200*","300*","500*"},F4:F14))