| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array error
Here is the formula (entered as an array):
{=SUM((A1:A4=A2)*(B1:B4=B2)*C1:C4)} Here is the table: School Year NO. OF PHYSICALS Jones 2008-2009 2 Sam 2008-2009 Alex 2008-2009 Why am I getting #Value instead of 2? -- Thanks Shawn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #Num error in Array | Excel Discussion (Misc queries) | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array error | Excel Programming | |||
| Array error | Excel Programming | |||
Threaded Mode
