SUMIF Question
 

I want to sum the values in cells E2:P110 based on the values column D. The
values in D are formulas resulting in something that appears to match D112 in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching. If
I enter the result of the formula, all is good. How should I deal with this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in message
...
I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

The formula is a VLOOKUP and it's pulling TEXT values.

"Tim C" wrote:

Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in message
...
I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

Barb,

Maybe trailing spaces?

Tim C

"Barb Reinhardt" wrote in message
...
The formula is a VLOOKUP and it's pulling TEXT values.

"Tim C" wrote:

Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value
of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in
message
...
I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match
D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal
with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

=SUMPRODUCT((D2:D110=D112)*(E2:P110))

Tim C wrote:
Barb,

Maybe trailing spaces?

Tim C

"Barb Reinhardt" wrote in message
...

The formula is a VLOOKUP and it's pulling TEXT values.

"Tim C" wrote:


Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value
of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in
message
...

I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match
D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal
with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

Hey Bob, I've not seen this symbol before - have you been able to
attach something here? I'm viewing through Google Groups.

Pete

SUMIF Question
 

Pete,

Do you mean that card type icon in the top-right corner? If so, that is a
personalised business card. I was playing with Mozilla Thunderbird
newsreader, and added one. Just trying it out.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Pete_UK" wrote in message
oups.com...
Hey Bob, I've not seen this symbol before - have you been able to
attach something here? I'm viewing through Google Groups.

Pete

SUMIF Question
 

Bob,

Let's say I want to concatenate B2 with D2 and compare it to B114, what do I
change? Or do I need to have a helper column?

=SUMPRODUCT((D2:D110=B114)*(E2:P110))

"Bob Phillips" wrote:

=SUMPRODUCT((D2:D110=D112)*(E2:P110))

Tim C wrote:
Barb,

Maybe trailing spaces?

Tim C

"Barb Reinhardt" wrote in message
...

The formula is a VLOOKUP and it's pulling TEXT values.

"Tim C" wrote:


Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value
of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in
message
...

I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match
D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal
with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

Bob, how would I count how many values in E2:P110 have values where the D
column values match D112.



"Bob Phillips" wrote:

=SUMPRODUCT((D2:D110=D112)*(E2:P110))

Tim C wrote:
Barb,

Maybe trailing spaces?

Tim C

"Barb Reinhardt" wrote in message
...

The formula is a VLOOKUP and it's pulling TEXT values.

"Tim C" wrote:


Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value
of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in
message
...

I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match
D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal
with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

No, you can do that

=SUMPRODUCT((B2:B110&D2:D110=B114)*(E2:P110))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Barb Reinhardt" wrote in message
...
Bob,

Let's say I want to concatenate B2 with D2 and compare it to B114, what do
I
change? Or do I need to have a helper column?

=SUMPRODUCT((D2:D110=B114)*(E2:P110))

"Bob Phillips" wrote:

=SUMPRODUCT((D2:D110=D112)*(E2:P110))

SUMIF Question
 

Just test the range rather than multiply it

=SUMPRODUCT((D2:D110=B114)*(ISNUMBER(E2:P110)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Barb Reinhardt" wrote in message
...
Bob, how would I count how many values in E2:P110 have values where the D
column values match D112.



"Bob Phillips" wrote:

=SUMPRODUCT((D2:D110=D112)*(E2:P110))

Tim C wrote:
Barb,

Maybe trailing spaces?

Tim C

"Barb Reinhardt" wrote in
message
...

The formula is a VLOOKUP and it's pulling TEXT values.

"Tim C" wrote:


Barb,

It sounds like a rounding issue. What you see displayed may not be
the
exact value of the cell. Try modifying your formulas to round the
value
of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in
message
...

I want to sum the values in cells E2:P110 based on the values column
D.
The
values in D are formulas resulting in something that appears to
match
D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not
matching.
If
I enter the result of the formula, all is good. How should I deal
with
this?

Thanks in advance,
Barb Reinhardt

SUMIF Question
 

Better switch to a Sum/If formula when a vector and a matrix involved:

=SUM(IF(D2:D100=D112,E2:P100))

which needs to be confirmed with control+shift+enter.

In fact, it's not unreasonable to create a total per record in an
aditional column and invoke an ordinary Sumif formula:

Q2, copied down:

=SUM(E2:P2)

Then:

=SUMIF(D2:D110,D112,Q2:Q110)

Barb Reinhardt wrote:
I want to sum the values in cells E2:P110 based on the values column D. The
values in D are formulas resulting in something that appears to match D112 in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching. If
I enter the result of the formula, all is good. How should I deal with this?

Thanks in advance,
Barb Reinhardt