SUMIF Function
 

Hey All,

Quick questions...hopefully...The formula works great for everything except
the '<3' and '20', why? It brings back a '0' for both. Am I suppose to use a
different function? I am still pretty new at this so any help would be
appreciated. Thanks in advanced

My formula is this...
=SUMIF(ManualData!H:H,A2,ManualData!G:G)

Columns have this in it...
ManualData!H:H
3-5
<3
<3
<3
3-5
<3
3-5
<3
6-10
3-5
3-5
6-10
6-10
6-10
20
3-5

A2
<3

ManualData!G:G
13
6
10
9
15
12
10
15
1
20
40
48
10
10
10

SUMIF Function
 

Try it like this:

=SUMIF(ManualData!H:H,"*"&A2,ManualData!G:G)

Your criteria, <3, was being evaluated as the logical expression: less than
3. Using the wildcard forces the criteria to be evaluated as the literal
TEXT string "<3".

--
Biff
Microsoft Excel MVP


"KS" wrote in message
...
Hey All,

Quick questions...hopefully...The formula works great for everything
except
the '<3' and '20', why? It brings back a '0' for both. Am I suppose to
use a
different function? I am still pretty new at this so any help would be
appreciated. Thanks in advanced

My formula is this...
=SUMIF(ManualData!H:H,A2,ManualData!G:G)

Columns have this in it...
ManualData!H:H
3-5
<3
<3
<3
3-5
<3
3-5
<3
6-10
3-5
3-5
6-10
6-10
6-10
20
3-5

A2
<3

ManualData!G:G
13
6
10
9
15
12
10
15
1
20
40
48
10
10
10

SUMIF Function
 

yes that solved it.....THANK YOU!!!!!!

"T. Valko" wrote:

Try it like this:

=SUMIF(ManualData!H:H,"*"&A2,ManualData!G:G)

Your criteria, <3, was being evaluated as the logical expression: less than
3. Using the wildcard forces the criteria to be evaluated as the literal
TEXT string "<3".

--
Biff
Microsoft Excel MVP


"KS" wrote in message
...
Hey All,

Quick questions...hopefully...The formula works great for everything
except
the '<3' and '20', why? It brings back a '0' for both. Am I suppose to
use a
different function? I am still pretty new at this so any help would be
appreciated. Thanks in advanced

My formula is this...
=SUMIF(ManualData!H:H,A2,ManualData!G:G)

Columns have this in it...
ManualData!H:H
3-5
<3
<3
<3
3-5
<3
3-5
<3
6-10
3-5
3-5
6-10
6-10
6-10
20
3-5

A2
<3

ManualData!G:G
13
6
10
9
15
12
10
15
1
20
40
48
10
10
10

SUMIF Function
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"KS" wrote in message
...
yes that solved it.....THANK YOU!!!!!!

"T. Valko" wrote:

Try it like this:

=SUMIF(ManualData!H:H,"*"&A2,ManualData!G:G)

Your criteria, <3, was being evaluated as the logical expression: less
than
3. Using the wildcard forces the criteria to be evaluated as the literal
TEXT string "<3".

--
Biff
Microsoft Excel MVP


"KS" wrote in message
...
Hey All,

Quick questions...hopefully...The formula works great for everything
except
the '<3' and '20', why? It brings back a '0' for both. Am I suppose to
use a
different function? I am still pretty new at this so any help would be
appreciated. Thanks in advanced

My formula is this...
=SUMIF(ManualData!H:H,A2,ManualData!G:G)

Columns have this in it...
ManualData!H:H
3-5
<3
<3
<3
3-5
<3
3-5
<3
6-10
3-5
3-5
6-10
6-10
6-10
20
3-5

A2
<3

ManualData!G:G
13
6
10
9
15
12
10
15
1
20
40
48
10
10
10