View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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.