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.