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")
Paul, let try more traditional way, this formula
=SUMPRODUCT(SUMIFS(B13:B135, A13:A135, Portfolio!A3:A125)*(Portfolio!B3:B125="1st LocatED Cluster")*(Portfolio!D3:D125="Response"))shall work practically on any version of Excel. Please check in attached file.
As for dynamic arrays and functions as FILTER() they are available for Office 365 subscribers.
