See if perhaps this might help you understand it even mo
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gazzr" wrote in message
...
Hi Dave,
User error I'm afraid, cell references were wrong, I was looking at Col
A, not Col AA.
Very happy that I know how to use SUMPRODUCT though!;)
Thanks again
Garry
--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile:
http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=557152