Sumif question

  • Thread starter Thread starter Travis
  • Start date Start date
T

Travis

I have a user that is having a problem with a workbook.
It has 5 sheets with a pretty significant amount of data in them and
the speed sucks, it is terribly slow and even on a faster machine when
it is calculating, it will max out the processor use. I don't really use
excel too much myself so I am passing this along. Recently another
worksheet was added and this one seems to be where the problem
originates. There are several sumif calculations that are being made so
each time you change anything, you have to wait a minute or two for it
to finish. I am pasting in the formula in hopes someone can tell me that
there is a better way to accomplish what he wants to do.
=SUMIF('Sales Detail'!A$2:K$7809,Sheet4!A$7:A$69,'Sales Detail'!I$2:I$7809)

Thanks for the help
 
There are several sumif calculations that are being made so
each time you change anything, you have to wait a minute or two for it
to finish.
Click to expand...

When you say several sumif calculations, how many? If there are a lot and
they are all looking at nearly 8000 rows, it will take a little while to
calculate.
The middle bit in your formula, Sheet4!A$7:A$69, puzzles me. What exactly is
it looking for?
 
Back
Top