Stop SumProduct formula from rounding up
 

Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

Stop SumProduct formula from rounding up
 

The cell with the formula is not rounding up. Format the cell with the
formula to General.
--
Gary''s Student - gsnu200780


"Judy L" wrote:

Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

Stop SumProduct formula from rounding up
 

Is the cell that shows 177 fornmatted to show zero decimals?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Judy L" wrote in message
...
Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

Stop SumProduct formula from rounding up
 

Thank you, but it is formatted to general.
Any other ideas?

"Gary''s Student" wrote:

The cell with the formula is not rounding up. Format the cell with the
formula to General.
--
Gary''s Student - gsnu200780


"Judy L" wrote:

Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

Stop SumProduct formula from rounding up
 

No it was formatted general.
But it is changed now, thanks. I thought it would read one decimal place
since it previewed in the formatting under general as 176.5?? And it was
working on the other sheet which is also formatted general. Unfortunately
there are a lot of 0 values and it looks busy with the 0.0 so I was hoping to
avoid that unless there was an actual decimal value.

Thanks for your help

"Sandy Mann" wrote:

Is the cell that shows 177 fornmatted to show zero decimals?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Judy L" wrote in message
...
Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

Stop SumProduct formula from rounding up
 

Widen the column--or change the font size.

If the cell is formatted as general, then excel will try to display what it can.

If you change the numberformat to Number, then if the text won't fit in the
cell, you'll see ###'s.



Judy L wrote:

Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

--

Dave Peterson

Stop SumProduct formula from rounding up
 

Thank you, you're right as usual!


"Dave Peterson" wrote:

Widen the column--or change the font size.

If the cell is formatted as general, then excel will try to display what it can.

If you change the numberformat to Number, then if the text won't fit in the
cell, you'll see ###'s.



Judy L wrote:

Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you

--

Dave Peterson