Thread: SUMIF Criteria
View Single Post
  #3   Report Post  
Brent
 
Posts: n/a
Default

Thanks, I can get the SUMPRODUCT to work, just seems more
complex then the
SUMIF function.
Can't figure out why this =SUMIF(DEC!
$D$3:$D$320,"32*",DEC!H$3:H$320) won't
work.
I get zero for the answer, but I use this formula on
another spreadsheet on
another computer and it works just fine.

Brent




-----Original Message-----
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

.