B
Brian Matlack
Hi!
I have a table of 7200 sumif statements (R 200 by C 36). They us
column A and Row 1 as criteria to show me qty of parts shipped by mont
for a 3 year period.
A B C
1|Part # |Jan-03|Feb-03|etc.
2|25-125 31 25
Problem is it takes my computer about 90 seconds to calculate all thes
statements. Is there a better way? Here is the formula I use in eac
cell.
=SUMIF('2003'!$L$3:$L$56085,$A5&"1",'2003'!$B$3:$B$56085)
A5 contains the part #, and "1" is for January and so-on
Any suggestions would be great!! Thanks for your time!
I have a table of 7200 sumif statements (R 200 by C 36). They us
column A and Row 1 as criteria to show me qty of parts shipped by mont
for a 3 year period.
A B C
1|Part # |Jan-03|Feb-03|etc.
2|25-125 31 25
Problem is it takes my computer about 90 seconds to calculate all thes
statements. Is there a better way? Here is the formula I use in eac
cell.
=SUMIF('2003'!$L$3:$L$56085,$A5&"1",'2003'!$B$3:$B$56085)
A5 contains the part #, and "1" is for January and so-on
Any suggestions would be great!! Thanks for your time!