Dear friends, I`m currently using CSE formulas to extract and analyse data
with the multiple criterias. e.g:
=SUM(('12SP'!$A$2:$A$65536=$A$1)*('12SP'!$G$2:$G$6 5536=$C$6)*('12SP'!$E$2:$E$65536<=$D$2)*('12SP'!$D $2:$D$65536))..But
unfortunately I have a problem with sheets so that everytime I face the
calculating cells %0..%100 phrase when I make any change. Perhaps it`s
because of heavy formulas..Anybody can help me in this issue?Thanks
beforehand.