Remember Me?

#1
January 7th 05, 01:13 AM
 Brent Martin Posts: n/a
SUMIF Criteria

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 ?

#2
January 7th 05, 01:37 AM
 Debra Dalgleish Posts: n/a

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

#3
January 7th 05, 02:08 AM
 Brent Posts: n/a

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

.

#4
January 7th 05, 02:49 AM
 Debra Dalgleish Posts: n/a

You can use the wildcard character with text in a SUMIF formula, e.g.

=SUMIF(DEC!\$D\$3:\$D\$320,"AB*",DEC!H\$3:H\$320)

but the wildcard character won't work with numbers.

Brent wrote:
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 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

.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

#5
January 7th 05, 04:03 AM
 Gary Rowe Posts: n/a

Could the format for the spreadsheet that works be different - text instead
of numeric?

"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 ?

#6
January 7th 05, 04:29 AM
 Brent Posts: n/a

Well, I did check the cells format in the spreadsheet
that does not work to make sure/change to numeric. That
still did not do anything. Did not check the overall
format of the sheet.

Thanks,

Brent
-----Original Message-----
Could the format for the spreadsheet that works be

of numeric?

"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 ?

.

#7
January 7th 05, 05:17 AM
 Gary Rowe Posts: n/a

Brent,
I set up a spreadsheet with a range of numbers entered as text. You need to
format the cells as text prior to entering the numbers. I set up another
range with numbers to add based on the criteria. The formula
(=SUMIF(D729,"*40",H7:H29) works. You can test the cells in your criteria
range by using the formula =istext(cell) and if it is it will result in True.
Gary

"Brent" wrote:

Well, I did check the cells format in the spreadsheet
that does not work to make sure/change to numeric. That
still did not do anything. Did not check the overall
format of the sheet.

Thanks,

Brent
-----Original Message-----
Could the format for the spreadsheet that works be

of numeric?

"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 ?

.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post anuita Excel Discussion (Misc queries) 1 January 4th 05 06:06 PM Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 09:56 PM C Cooper Midland Excel Discussion (Misc queries) 2 December 14th 04 02:49 PM Spunky Excel Discussion (Misc queries) 9 December 3rd 04 06:07 PM

All times are GMT +1. The time now is 09:05 AM.