SUMIF function using Criteria on different worksheet
I have a SUMIF function analysing data across different worksheets. However
currently I am manually typing in the "Criteria" (which is in text form) in
to each different equation. The Criteria list is available on a seperate
worksheet, can I simply refer the equation to look at a defined cell in
another worksheet.
For example
=SUMIF('Outgoings'!$E$9:$E$26,"=Electricity",'Outg oings'!$I$9:$I$26)
So if the word "Electricity" is in cell 'Purchase List'!G8 can the formula
refer to the cell rather than the word Electricity?
Thanks in advance, a Taxed Mind.
|