I forgot to mention that I am pulling information from other unopen excel
files so the sumif calc will not work. That is why I was trying the
sumproduct and sumif with the array. My same question still applies. Any
suggestions?

"Robert" wrote:

I am trying to use the sumif or sumproduct formula and am coming up with
either no data or incorrect data.

=SUMIF('2007-01'!$E$3:$E$500,B:B,'2007-01'!$I3:$I$500)/1000000 ---- Gives
back a zero

{=SUMPRODUCT(--('2007-01'!$E$3:$E$500,$B:$B,'2007-01'!$I$3:$I$500))/100000}
----- Gives back #value!


{=SUM(IF('2007-01'!$E$3:$E$500,$B:$B,'2007-01'!$I$3:$I$500))/100000} ----
Gives back a value of the entire column I and is ignoring the criteria in
$B:$B

Any help would be greatly appreciated.

Robert