(First post - by no means expert, but not an idiot either). I have used this simple formula =IF(A2="Tot",SUMIF(A:A,A1,L:L),""), copied down a column; mostly it gives the correct result, but on two occasions it gives the same, manifestly wrong, figure : 9.35. The first such occasion is actually the first time the formula gives a non-null result ; the figures it should have totalled are -2.00,-2.00,-5.00,-5.00 (and there are no others so far, so it couldn't have picked up any by mistake), so how can it sum these up as 9.35 (and since these figures are at the start of the sheet, I can easily see that there are no figures anywhere in the sheet at that point from which , however they are combined, 9.35 could be produced.) The second occasion occurs as the sixth non-null result in (so far) a total of 9. In this case , the figures which are totalled as 9.35 are in fact 10.54 and 12.81 - again , a surreal result. Needless to say, I've checked a dozen times , but I'm totally baffled. I should be grateful if anyone can suggest any explanations.
Bookmarks