FARAZ QURESHI;348957 Wrote:
How can I use a formula like:
=SUMPRODUCT(--(Jan!$H:$H=$A3)*--(Jan!$J:$J=B$1)*--(Jan!$J:$J<=B$2),Jan!$J:$J)
for multiple sheets? Following formula is not working:
=+SUMPRODUCT(--(Jan:Dec!$H:$H=$A3)*--(Jan:Dec!$J:$J=B$1)*--(Jan:Dec!$J:$J<=B$2),Jan:Dec!$J:$J)
It is resulting into a #Name? error.
Any suggestions?
Thanx in advance.

Hi,
in XL versions before 2007 entire columns like H:H are not allowed.
If needed try H1:H65535 or better still, use dynamic references


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97606