How do you correct inaccurate sumif totals?

[Guest]

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?

 

[Peo Sjoblom]

Hardly, probably erroneous data or formula.

Post your formula and explain the data layout

 

[joeu2004]

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.