software

I have a SUMIF function analysing data across different worksheets. However
currently I am manually typing in the quot;Criteriaquot; (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,quot;=Electricityquot;,'Outg oings'!$I$9:$I$26)

So if the word quot;Electricityquot; is in cell 'Purchase List'!G8 can the formula
refer to the cell rather than the word Electricity?

Thanks in advance, a Taxed Mind.

Try...

=SUMIF('Outgoings'!$E$9:$E$26,'Purchase List'!G8,'Outgoings'!$I$9:$I$26)

Hope this helps!

In article gt;,
Taxed Mind lt;Taxed gt; wrote:

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

You need to refer to the cell itself, not whats in it, eg if 'Electricity'
were in B7 in Sheet3 then,

=SUMIF('Outgoings'!$E$9:$E$26,Sheet3!B7,Outgoings' !$I$9:$I$26)

or if you name Sheet3 B7 'Electricity'

=SUMIF('Outgoings'!$E$9:$E$26,Electricity,Outgoing s'!$I$9:$I$26)
Regards,
Alan.

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