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...
Riny_van_Eekelen
Jan 12, 2022Platinum Contributor
Larry1921 Just to point out the problem in your original formula. You used cursive quotation marks around the t.
Replace them by regular (straight) quotation marks, and the formula shall work as intended, though shortening it in accordance with OliverScheurich suggestion would be a good idea.
Larry1921
Jan 17, 2022Copper Contributor
Thanks, got it working now.