Re: SUMPRODUCT help needed
- From: duane <duane.1qjoab_1118631906.4074@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 12 Jun 2005 21:49:34 -0500
sounds like
=SUMPRODUCT((Sheet1!B2:B100="restored")*(Sheet1!C2:C100=Sheet2!A2:A100))
adjust the ranges as required
--
duane
------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11624
View this thread: http://www.excelforum.com/showthread.php?threadid=378442
.
- References:
- SUMPRODUCT help needed
- From: bradgrafelman
- SUMPRODUCT help needed
- Prev by Date: How do I make a blank cell with a date format blank?
- Next by Date: Re: Replace "-" with "0"
- Previous by thread: Re: SUMPRODUCT help needed
- Next by thread: Counting within a filtered range
- Index(es):
