Try

=SUMPRODUCT(--(C6:C403=A6),--(D6:D403=A6))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"SamGB" wrote
in message
...

Im using this formula:
=SUMPRODUCT(--(C6:C403="??"),--(D6:D403="??"))
which works well, however where the "??" are placed i would
like to
enter a cell location i.e "A6" which will use whatever text is
in the
cell to perform the sum. Is this possible? it would save alot
of time
rather than changing criteria in the formula everytime

Help is much appreciated


--
SamGB
------------------------------------------------------------------------
SamGB's Profile:
http://www.excelforum.com/member.php...o&userid=31263
View this thread:
http://www.excelforum.com/showthread...hreadid=516363