How do I specify cell contents for the Criteria in SUMIF?
 

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.

How do I specify cell contents for the Criteria in SUMIF?
 

This can be done. Something like:

=SUMIF(A1:A10,C1,B1:B10)

This checks for the value of C1 in the range A1:A10, then adds B1:B10.

HTH,
Elkar


"Michael" wrote:

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.

How do I specify cell contents for the Criteria in SUMIF?
 

for other than equal condition, use:

=SUMIF(A1:A10,"" &C1,B1:B10)

"Elkar" wrote:

This can be done. Something like:

=SUMIF(A1:A10,C1,B1:B10)

This checks for the value of C1 in the range A1:A10, then adds B1:B10.

HTH,
Elkar


"Michael" wrote:

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.

How do I specify cell contents for the Criteria in SUMIF?
 

"Michael" wrote:

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.

I am getting an error with the following when trying to do a logical operator:
=SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288)
I have tried it with and without the quotes and still get an error message.

How do I specify cell contents for the Criteria in SUMIF?
 

I am getting an error with the following when trying to do a logical
operator:
=SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288)
I have tried it with and without the quotes and still get an error
message.

Concatenate the "" with the contents of $D$3...

=SUMIF($N$8:$N$288,""&$D$3,$D$8:$D$288)

Rick

How do I specify cell contents for the Criteria in SUMIF?
 

As per my previous reply:

=SUMIF($N$8:$N$288,"" & $D$3,$D$8:$D$288)


"Michael" wrote:



"Michael" wrote:

I am trying to use the cell contents as the Criteria specification as opposed
to a fixed text operator and cannot seem to figure out how to do it or if it
can be done.

I am getting an error with the following when trying to do a logical operator:
=SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288)
I have tried it with and without the quotes and still get an error message.

How do I specify cell contents for the Criteria in SUMIF?
 

"Rick Rothstein (MVP - VB)" wrote:

I am getting an error with the following when trying to do a logical
operator:
=SUMIF($N$8:$N$288,"$D$3",$D$8:$D$288)
I have tried it with and without the quotes and still get an error
message.

Concatenate the "" with the contents of $D$3...

=SUMIF($N$8:$N$288,""&$D$3,$D$8:$D$288)

Rick


Super! Thanks!!!!