Thank you for the post, but will this search a range of data and
reference a specific cell based upon the first two sets of criteria?


Irina Wrote:
Try to use this formula:

=SUMPRODUCT((Sheet1!A$1:A$4="Feb")*(Sheet1!B$1:B$4 ="Sales")*(Sheet1!C$1:C$4))


--
doug1
------------------------------------------------------------------------
doug1's Profile: http://www.excelforum.com/member.php...o&userid=30746
View this thread: http://www.excelforum.com/showthread...hreadid=522387