Hello,
I need help in a matter.
I have a 4 page excel file in the current file. the master page will be filled in and the data should be on the amount and endorsement pages. the graphics will be updated on the graphic page I prepared from these 2 pages. I tried this formula but it gave the values error.
=SUMIFS(Master!D:U;Master!B:B;B:B;Master!C:C;C:C;Master!1:1;D1;Master!2:2;D2)
Last edited by CaffeineCY; 06-13-2018 at 10:17 AM.
The columns to be SUMed and the criteria range have to be the same size so
=SUMIFS(Master!D:U;Master!B:B;B:B;Master!C:C;C:C;Master!1:1;D1;Master!2:2;D2)
will not work
and you have criteria columns and rows.
You will need to use SUMPRODUCT BUT do not have whole column/whole row ranges e,g use D2:D1000 rather than D:D
and where is the formula???
Try
=SUMIFS(INDEX(Master!$D:$U,0,MATCH(E$1,Master!$D$1:$U$1,0)),Master!$B:$B,$B3,Master!$C:$C,$C3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks