Forum Discussion
SUMIFS retrun #VALUE
This is the formula that I think should work fine but I get #VALUE returned! =SUMIFS(B13:B63, Portfolio!H3:H117, "1st LocatED Cluster", Portfolio!K3:K120, "=Response")
Again, I'd recommend first to make ranges of same size. If after that you still have an error, when better to check the file.