Hi,

I'm trying this formula but it throws a #NAME? error.

=SUMRPRODUCT(('North America'!O2:O1090TODAY)*('North
America'!H2:H1090="Single User"))

Anyone have any idea where the problem might be?

Thanks,
D


--
dungeonboy
------------------------------------------------------------------------
dungeonboy's Profile: http://www.excelforum.com/member.php...o&userid=26140
View this thread: http://www.excelforum.com/showthread...hreadid=387925