Try this:

=SUM(((INDIRECT("Wrestlers_Statistics!$B$"&2):$B$6 4998)=$A$3)*(INDIRECT("Wrestlers_Statistics!$M$"&2 ):$M$64998))


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489179

I appreciate the help, and I was starting to play with the INDIRECT
function (new to me), but this particular function doesn't work. It
returns a #VALUE! error. When I Evaluate the Formula, the first item
it displays as in error is SUM(((_Wrestlers_Statistics!$B$2:$B$64998)_

After pressing Evaluate, it returns SUM(((#VALUE!)=$A$3)...

Something is wrong with that first part.

I've copied it exactly as written, and I've tried both CTRL-ALT-ENTER,
and just ENTER.

Neither works. Is there just a syntax error is is there something else
I can try?


--
rmolitor
------------------------------------------------------------------------
rmolitor's Profile: http://www.excelforum.com/member.php...o&userid=29190
View this thread: http://www.excelforum.com/showthread...hreadid=489179

Does this work for you ?


=SUM(((INDIRECT("Wrestlers_Statistics!$B$"&2&":$B$ "&64998)=$A$3)*(INDIRECT("Wrestlers_Statistics!$M$ "&2&":$M$"&64998))))


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489179

Thank you Viti, this did indeed get my problem fixed. I also used a
very similar formula to seek out a specific string from a column on
another page using the INDIRECT funtion and add them up. That worked
wonderfully!

Thanks for you help!


--
rmolitor
------------------------------------------------------------------------
rmolitor's Profile: http://www.excelforum.com/member.php...o&userid=29190
View this thread: http://www.excelforum.com/showthread...hreadid=489179