Hey guys.

I was wondering if anyone could help me out with this function "value"
error. Basically I am trying to sum using multiple arrays. I want to
sum by name, stage, and date range. In the following formula the first
array corresponds to name, the second two correspond to date, and the
last array corresponds to stage. Basically I want to sum the number of
instances per stage per person. When I enter the following formula, I
get the value error and I dont see why. If anyone can help me with
this, I would really appreciate it. Thank You



=SUMPRODUCT(--('Lead Data'!$K$6:$K$504='Lead Data'!$M8),--('Lead
Data'!$A$6:$A$504=DATEVALUE("1/01/2006")),--('Lead
Data'!$A$6:$A$504<=DATEVALUE("1/06/2006")),--('Lead Data'!D6:D160='Lead
Data'!N7))


--
mhall5
------------------------------------------------------------------------
mhall5's Profile: http://www.excelforum.com/member.php...o&userid=30087
View this thread: http://www.excelforum.com/showthread...hreadid=551224

Your problem is inconsistent range sizes. You have three ranging from 6-504,
one from 6-160. They must be the same size.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"mhall5" wrote in
message ...

Hey guys.

I was wondering if anyone could help me out with this function "value"
error. Basically I am trying to sum using multiple arrays. I want to
sum by name, stage, and date range. In the following formula the first
array corresponds to name, the second two correspond to date, and the
last array corresponds to stage. Basically I want to sum the number of
instances per stage per person. When I enter the following formula, I
get the value error and I dont see why. If anyone can help me with
this, I would really appreciate it. Thank You



=SUMPRODUCT(--('Lead Data'!$K$6:$K$504='Lead Data'!$M8),--('Lead
Data'!$A$6:$A$504=DATEVALUE("1/01/2006")),--('Lead
Data'!$A$6:$A$504<=DATEVALUE("1/06/2006")),--('Lead Data'!D6:D160='Lead
Data'!N7))


--
mhall5
------------------------------------------------------------------------
mhall5's Profile:
http://www.excelforum.com/member.php...o&userid=30087
View this thread: http://www.excelforum.com/showthread...hreadid=551224

Hey thanks alot. I was really agonizing over this today. Its funny how
these problems occur over something so minute. Anyways thanks alot


--
mhall5
------------------------------------------------------------------------
mhall5's Profile: http://www.excelforum.com/member.php...o&userid=30087
View this thread: http://www.excelforum.com/showthread...hreadid=551224