How do you correct inaccurate sumif totals?
On Aug 15, 3:34 pm, Analyst wrote:
I use the sumif functions quite a bit, however, today I am getting an
inaccurate total on my sumif formula. What is drving this? Is the file
size a problem?
We are experts at mindreading, but your brain is just not putting out
enough energy. Perhaps you could describe the nature of the
"inaccuracy". (Duh!)
Let me more specific: SUMIF returns what, and you expect what?
Could the difference be explained by a programming of your own; that
is, the conditional expression is not working the way you expect?
Could the difference be explained by rounding in the __display__ of
intermediate values (those cells being summed), but the underlying
values are different?
The latter is a very common programming mistake (of the user's).
There are several ways to work around it.
But before I leap into problem-solving mode, it would be nice to know
what the problem is.
|