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