Help with SUMIF formula

[amitubale]

I am trying to sum every nth cell.
Users from this forum gave me the tips earlier for the same exce
sheet.
Its difficult to describe the nature of the problem here.
Here is the link for the excel sheet
http://homepages.wmich.edu/~s8ubale/test.xls

I should be getting a whole number in cell C119

 

[JulieD]

hi

the reason is that the value in cell C105 isn't a whole number

regards
JulieD

 

[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

 

[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

 

[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.

 

[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)