|
|
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(Resul ts,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.a...tions/200508/1
|