I am working on a spreadsheet that supposed to sum across all my worksheets. Basically, I have a summary page and several other pages with montly records. On my monthly records I have Employee Names on the left and Serial Numbers on top. My summary page supposed to calculate how many hours each employee spend on each serial number. To get an idea of what I am doing please see attachement.
I used this formula; however, I get a #Value! error.
=SUMPRODUCT((INDIRECT("'"&$A$13:$A$14&"'!$A$2:$A$4"))=A2)*((INDIRECT("'"&$A$13:$A$14&"'!$B$1:$C$1"))=B1)*((INDIRECT("'"&$A$13:$A$14&"'!$B$2:$C$4")))
Could anybody help with this issue? Is there alternative formula that I could use??
Thanks!
Sample.xlsx
Bookmarks