I'm trying to get a total from my using a Sumproduct formula. In Sheet2 is where the data is that I'm trying to extract. On Sheet2 column I through T is where the Month totals are that I'm trying to extract. I get a result of #VALUE!.
=SUMPRODUCT(--(Sheet2!$C:$C=$A$2),--(Sheet2!$E:$E=$B2),--(Sheet2!$I:$T=$C2),(Sheet2!I:T))
Name ID# Date Tracey 123456 October
Thank you.
Bookmarks