Conversation Re: SUMIFS formula help in Excel
https://techcommunity.microsoft.com/t5/excel/sumifs-formula-help/m-p/356271#M26276
Hi<BR /><BR />So rather than hardcoding 7508 just type '7508 into cell A1 and change your formula to <BR /><BR />=SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,A1)<BR /><BR />Just an extra question - is a Pivot Table not a suitable solution in this scenario?<BR />Mon, 25 Feb 2019 13:22:31 GMTWyn Hopkins2019-02-25T13:22:31ZSUMIFS formula help
https://techcommunity.microsoft.com/t5/excel/sumifs-formula-help/m-p/356240#M26272
<P>I currently use this formula</P><P> </P><P>=SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,"7508")</P><P> </P><P>This will search a worksheet for the number 7508 in a column K and then add all of the costs in Column F if column K returns the correct data. </P><P> </P><P>We have thousands of codes - up to 8500 so at the moment i work out which codes are in the transactions worksheet and then manually change each formula </P><P> </P><P>What i want to be able to do is in my work sheet enter the codes into a coloumn and have the formula automatically change do in my above formula i want 7508 to actually be cell reference so i can change what data is in the cell and searched for eg change it to 4011 and have the formula return the total amount of any entries using that code</P><P> </P><P>hope that makes sense!!</P>Mon, 25 Feb 2019 12:15:46 GMThttps://techcommunity.microsoft.com/t5/excel/sumifs-formula-help/m-p/356240#M26272joanneosp2019-02-25T12:15:46ZRe: SUMIFS formula help
https://techcommunity.microsoft.com/t5/excel/sumifs-formula-help/m-p/356271#M26276
Hi<BR /><BR />So rather than hardcoding 7508 just type '7508 into cell A1 and change your formula to <BR /><BR />=SUMIFS(Transactions!$F$3:$F$17,Transactions!$K$3:$K$17,A1)<BR /><BR />Just an extra question - is a Pivot Table not a suitable solution in this scenario?<BR />Mon, 25 Feb 2019 13:22:31 GMThttps://techcommunity.microsoft.com/t5/excel/sumifs-formula-help/m-p/356271#M26276Wyn Hopkins2019-02-25T13:22:31Z