You could use the SUMPRODUCT function instead. For example:
=SUMPRODUCT((LEFT(B2:B100,2)="32")*(B2:B100))
Brent Martin wrote:
In the criteria section of SUMIF function I cannot get
the wildcard function to work. "32*"
It works fine for me on another computer, is there some
setting or something that I should check for on this
computer to make it work ?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html