Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF function using Criteria on different worksheet
Try...
=SUMIF('Outgoings'!$E$9:$E$26,'Purchase List'!G8,'Outgoings'!$I$9:$I$26) Hope this helps! In article , Taxed Mind <Taxed wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF function using Criteria on different worksheet
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. "Taxed Mind" <Taxed wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif function with multiple criteria | Excel Worksheet Functions | |||
SUMIF With Multiple Criteria | Excel Worksheet Functions | |||
Can I use two criteria in the SUMIF worksheet function? | Excel Discussion (Misc queries) | |||
SUMIF function referring to values on different Worksheet | Excel Worksheet Functions | |||
Help with SUMIF function criteria | Excel Worksheet Functions |