I am trying to use the SUMPRODUCT function, however I keep receiving the "#Value" error. Basically, if the two criteria are met in a row, I want a certain column to sum for those particular rows. For example if J2 and J4 both contain "MED.AM" and A2 and A4 both equal A6 then I want to sum P2 and P4. I can't seem to figure it out. Can someone please assist and explain? I hope this makes sense.
=SUMPRODUCT(--('results(1)'!J:J="MED.AM"),--('results(1)'!A:A=Sheet1!A6),--('results(1)'!L:L))
As usual, best forum ever and I appreciate your help!
Bookmarks