Forum Discussion
SUMIFS formula help
I currently use this formula =SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,"7508") This will search a worksheet for the number 7508 in a column K and then add all of the costs in Co...
Hi
So rather than hardcoding 7508 just type '7508 into cell A1 and change your formula to
=SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,A1)
Just an extra question - is a Pivot Table not a suitable solution in this scenario?
So rather than hardcoding 7508 just type '7508 into cell A1 and change your formula to
=SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,A1)
Just an extra question - is a Pivot Table not a suitable solution in this scenario?