Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Formula
I need some help. I am trying to create a formula where I reference two
different cells in one spreadsheet that are in the same row(this is the critera that I am pulling from on a "Data" page). On a separate tab I need to average the numbers that coincide with the referenced cell from the original tab. A simple Vlookup formula doesn't work because it only uses one description as a qualifier. Please Help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Formula
Do you mean
=SUM((Sheet2!A2:A20="value1")*(Sheet2!B2:B20="valu e2")) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Watty30" wrote in message ... I need some help. I am trying to create a formula where I reference two different cells in one spreadsheet that are in the same row(this is the critera that I am pulling from on a "Data" page). On a separate tab I need to average the numbers that coincide with the referenced cell from the original tab. A simple Vlookup formula doesn't work because it only uses one description as a qualifier. Please Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex formula | Excel Discussion (Misc queries) | |||
Can someone help with this complex formula? | Excel Worksheet Functions | |||
Need Help with complex formula | Excel Worksheet Functions | |||
I Need Help with complex formula ? | Excel Worksheet Functions | |||
Complex =mid formula | Excel Worksheet Functions |