Sumif not criteria
 

I'm trying to sum a column of data "B", but only if column "A" does not equal
X.

Sumif not criteria
 

=Sum(A1:A3)=x*SUM(B1:B3)


"CCrew2000" wrote in message
...
I'm trying to sum a column of data "B", but only if column "A" does not
equal
X.

Sumif not criteria
 

I forgot to mention that Column A is text. Values in column B

"JethroUK©" wrote:

=Sum(A1:A3)=x*SUM(B1:B3)


"CCrew2000" wrote in message
...
I'm trying to sum a column of data "B", but only if column "A" does not
equal
X.

Sumif not criteria
 

Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does not equal
X.

Sumif not criteria
 

so what might Col A (e.g. A1:A3) not equal ?


"CCrew2000" wrote in message
...
I forgot to mention that Column A is text. Values in column B

"JethroUK©" wrote:

=Sum(A1:A3)=x*SUM(B1:B3)


"CCrew2000" wrote in message
...
I'm trying to sum a column of data "B", but only if column "A" does
not
equal
X.

Sumif not criteria
 

I'm having the same problem. I tried Domenic's suggestion but didn't work -
any others?

"Domenic" wrote:

Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does not equal
X.

Sumif not criteria
 

I should also maybe add that I'm trying to use a cell reference as my
criteria - does this make a difference?

I'm trying to do =SUMIF(C122:C127,"<$C$2",D122:D127) but it just sums
everything, without taking into account the criteria.

"doublew" wrote:

I'm having the same problem. I tried Domenic's suggestion but didn't work -
any others?

"Domenic" wrote:

Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does not equal
X.

Sumif not criteria
 

It's a little different when using a cell reference:

=SUMIF(C122:C127,"<"&$C$2,D122:D127)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"doublew" wrote in message
...
I should also maybe add that I'm trying to use a cell reference as my
criteria - does this make a difference?

I'm trying to do =SUMIF(C122:C127,"<$C$2",D122:D127) but it just sums
everything, without taking into account the criteria.

"doublew" wrote:

I'm having the same problem. I tried Domenic's suggestion but didn't
work -
any others?

"Domenic" wrote:

Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does
not equal
X.

Sumif not criteria
 

That worked perfectly, thanks so much!

"RagDyeR" wrote:

It's a little different when using a cell reference:

=SUMIF(C122:C127,"<"&$C$2,D122:D127)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"doublew" wrote in message
...
I should also maybe add that I'm trying to use a cell reference as my
criteria - does this make a difference?

I'm trying to do =SUMIF(C122:C127,"<$C$2",D122:D127) but it just sums
everything, without taking into account the criteria.

"doublew" wrote:

I'm having the same problem. I tried Domenic's suggestion but didn't
work -
any others?

"Domenic" wrote:

Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does
not equal
X.