Hello,
I am working on an interactive table
Depending on drop down menus, the values of a table are supposed to change and sum different rows of data.
=SUMIFS('Sheet1'!$X:$X,'Sheet1'!$AR:$AR,report!$F$5,'Sheet1'!Q:Q,report!D33,'Sheet1'!$Q:$Q,Sheet1!B35,)
want to add another criteria and range which depend on drop a down menu outcomes 1,2,3
if 1 look for criteria in column $A
if 2 look for criteria in column $B
if 3 look for criteria in column $c
(criteria stays the same)
How could I integrate this into the sumifs formula?
Thanks
Bookmarks