#1   Report Post  
Old January 7th 05, 01:13 AM
Brent Martin
 
Posts: n/a
Default 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   Report Post  
Old January 7th 05, 01:37 AM
Debra Dalgleish
 
Posts: n/a
Default

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   Report Post  
Old January 7th 05, 02:08 AM
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

.

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

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

.




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

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

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   Report Post  
Old January 7th 05, 04:29 AM
Brent
 
Posts: n/a
Default

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

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 ?

.

  #7   Report Post  
Old January 7th 05, 05:17 AM
Gary Rowe
 
Posts: n/a
Default

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

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 ?

.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SumIF anuita Excel Discussion (Misc queries) 1 January 4th 05 06:06 PM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM
Sum or Sumif Frank Kabel Excel Discussion (Misc queries) 1 December 15th 04 09:56 PM
formula that meets two criteria and sums? C Cooper Midland Excel Discussion (Misc queries) 2 December 14th 04 02:49 PM
sumif Spunky Excel Discussion (Misc queries) 9 December 3rd 04 06:07 PM


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017