Dear sir,
I have a problem regarding the SUMPRODUCT function. I used to add some
numbers from number of worksheets such as WK1, WK2, WK3 etc. As a result, my
formula become very long as following:
=SUMPRODUCT((WK1!$E$2:$E$100=$D8)*(G$3<WK1!$B$2:$B $100)*(WK1!$B$2:$B$100<=H$3)
,(WK1!$D$2:$D$100))+SUMPRODUCT((WK2!$E$2:$E$100=$D 8)*(G$3<WK2!$B$2:$B$100)*
(WK2!$B$2:$B$100<=H$3),(WK2!$D$2:$D$100))+SUMPRODU CT((WK3!$E$23:$E$100=$D8)*
(G$3<WK3!$B$2:$B$100)*(WK3!$B$2:$B$100<=H$3),(WK3! $D$2:$D$100))

My question is that is there any way to have one formula which can perform
the same function, just like this example, instead of make such long formula
like this:

=SUM('Worksheet 2'!A1:A10)+SUM('Worksheet 3'!A1:A10), I can have this more
shorten formula to replace the long one: =SUM('Worksheet 2:Worksheet 3'!A1:
A10).

Please advice.
Wilchong

--
Message posted via http://www.officekb.com