So I have a strange problem... I'm using excel 2007 and I have a sumif formula that calculates through about 5000 rows of data.
One row has this formula in it:
=SUMIF($G$1:$G1,$G2,L$1:L1)+SUMIF($H$1:$H1,$G2,AB$1:AB1)
Another row has almost the exact same formula but reversed:
=SUMIF($H$1:$H1,$G2,L$1:L1)+SUMIF($G$1:$G1,$G2,AB$1:AB1)
The formula is copied all the way down 5000+ rows in each column. Here's my problem -- in the first column the calculations take a long time and after they finish and I attempt to do a paste special->values excel takes FOREVER to accomplish this (like 3+ hours). In the other column with almost the exact same formula calculation time is quick and paste special->values is instantaneous. What's up?
Bookmarks