Hi all,
I've been searching the internet for a few days and cannot seem to find the solution to my problem. I can usually figure out/ find on the internet solutions but I'm stumped as to why the following equation won't work: {=SUMPRODUCT((Data!$C$2:$C$13189),(--(Data!$B$2:$B$13189=$B$2)*(--(MATCH(Output!$A$2:$A$26,Data!$A$2:$A$13189,0)))))}
I need to be able to get the Total for the selection. The Data!$C$2:$C$13189 is the dollars I need and Data!$B$2:$B$13189=$B$2 is my year criteria which both work fine. When I add in the Office criteria, I get #N/A. I'm trying to allow the user to select multiple offices and I need the sumproduct to look up every office put into the Output!$A$2:$A$26 range in the Data!$A$2:$A$13189 range.
Any help will be greatly appreciated!
Bookmarks