Help with SUMIF formula

R

Robert Rosenberg

Cell C105 is not a whole number. Add a few decimals and you'll see a
remainder that matches the remainder in the total.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
K

Kent

Saw your sheet. Is this what you are after?

In C119, =SUMIF($B$1:$B$118,$B$5,C1:C118)

This should be draggable(autofill) across the row which
should give you 324 in C119, 318 in D119, etc.

Excel Support Technician
www.canhelpyou.com
 
K

Ken Wright

Well Julie has nailed it with the reason why, and it looks you are simply linked
to the wrong number back on the other file. What is probably throwing you
though, is that you had a whole number before you put in the SUMIF function.
Well that is because your other formulas don't actually cover the entire sheet,
and all stop at row 60 which is before you have this issue with a dodgy link, so
likely as not the formula you had in the cell before SUMIF went in was the same.
 
B

Bob Phillips

The value in C105 has a decimal portion which is reflected in the total. It
just doesn't show, as it is formatted to 0 dec places. But if you look at
C107, which has a formula of C105, it shows those decimal places.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top