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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
array error
Shawn
Your including the header, try this =SUM((A2:A4=A2)*(B2:B4=B2)*C2:C4) we get an answer of 2 Mike "Shawn" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
array error
I am still getting the #Value. I didn't include the header in the actual
formula, that was a typo in my post. -- Thanks Shawn "Mike H" wrote: Shawn Your including the header, try this =SUM((A2:A4=A2)*(B2:B4=B2)*C2:C4) we get an answer of 2 Mike "Shawn" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
array error
By the way, I suspect it is some sort of formatting problem.???
-- Thanks Shawn "Shawn" wrote: I am still getting the #Value. I didn't include the header in the actual formula, that was a typo in my post. -- Thanks Shawn "Mike H" wrote: Shawn Your including the header, try this =SUM((A2:A4=A2)*(B2:B4=B2)*C2:C4) we get an answer of 2 Mike "Shawn" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
array error
It is a formatting problem because we I manually retype duplicate enteries in
a seperate worksheet and use the exact same formula, it works?????? -- Thanks Shawn "Shawn" wrote: By the way, I suspect it is some sort of formatting problem.??? -- Thanks Shawn "Shawn" wrote: I am still getting the #Value. I didn't include the header in the actual formula, that was a typo in my post. -- Thanks Shawn "Mike H" wrote: Shawn Your including the header, try this =SUM((A2:A4=A2)*(B2:B4=B2)*C2:C4) we get an answer of 2 Mike "Shawn" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
array error
Maybe you have white space (like those HTML non-breaking spaces) in C2:C4.
Shawn wrote: It is a formatting problem because we I manually retype duplicate enteries in a seperate worksheet and use the exact same formula, it works?????? -- Thanks Shawn "Shawn" wrote: By the way, I suspect it is some sort of formatting problem.??? -- Thanks Shawn "Shawn" wrote: I am still getting the #Value. I didn't include the header in the actual formula, that was a typo in my post. -- Thanks Shawn "Mike H" wrote: Shawn Your including the header, try this =SUM((A2:A4=A2)*(B2:B4=B2)*C2:C4) we get an answer of 2 Mike "Shawn" wrote: 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 -- Dave Peterson |
Reply |
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 |