Quote Originally Posted by MarvinP View Post
Hi madmanmac,

Find attached your answer. Have fun with the kids. You needed this formula in Cell C77 and pull down and across.
=SUMPRODUCT(--($B$4:$B$70=$B77),C$4:C$70)
Read http://ezinearticles.com/?Excels-SUM...al!&id=1971142 for more in depth understanding.


Turns out I won't need it until next year. Yesterday afternoon, my son and some friends were goofing around at the ball field and he got hit in the with a batted ball. He has a small skull fracture but thank the Lord he will be OK. They said he was very close to having to have an operation.

Just no ball playing for six months. Baseball is both mine and his favorite sports so it will
be a wierd summer not being at his games.

But I'll save this until next season. Thanks for your help.