Forum Discussion
Larry1921
Jan 11, 2022Copper Contributor
sumifs
I am trying to do a sumifs for 3 different criteria and having trouble. Working on Sheet 1 I am trying to sum the total number of 'bins' (column L on Summary Total tab) if the bins are the quanti...
OliverScheurich
Jan 11, 2022Gold Contributor
=SUMIFS('Summary Totals'!$L$19:$L$1894,'Summary Totals'!$K$19:$K$1894,"t",'Summary Totals'!$D$19:$D$1894,L$6,'Summary Totals'!$B$19:$B$1894,$A8)
Maybe with this formula.