Re: SUMPRODUCT Help

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Sam via OfficeKB.com" <forum@xxxxxxxxxxxx>
Date: Tue, 30 Aug 2005 01:24:11 GMT

Hi Domenic,

I used your second option: Formula works great! Thank you very much.

>=SUMPRODUCT((OFFSET(Results,0,2,,5)=$D$4)*(MONTH(OFFSET(Results,0,1,,1))=MONTH($B$6))*(OFFSET(Results,0,1,,1)<>""))

Cheers,
Sam

Domenic wrote:
>Try...
>
>=SUMPRODUCT((OFFSET(Results,0,2,,5)=$D$4)*(MONTH(OFFSET(Results,0,1,,1))=
>MONTH($B$6)))
>
>Note that if B6 contains a date whose month is January, all empty cells
>in your date range will be evaluated as TRUE. You may want to try the
>following instead...
>
>=SUMPRODUCT((OFFSET(Results,0,2,,5)=$D$4)*(MONTH(OFFSET(Results,0,1,,1))=
>MONTH($B$6))*(OFFSET(Results,0,1,,1)<>""))
>
>Hope this helps!
>
>> Hi All,
>>
>[quoted text clipped - 18 lines]
>> Thanks
>> Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200508/1
.

References:
- SUMPRODUCT Help
  - From: Sam via OfficeKB.com
- Re: SUMPRODUCT Help
  - From: Domenic

Prev by Date: RE: How do I find address of cell containing maximum value
Next by Date: Input to populate report work***
Previous by thread: Re: SUMPRODUCT Help
Next by thread: DATEVALUE QUESTION
Index(es):
- Date
- Thread