Hi Bob,
Thanks for reply. I've entered the array Formula (with Ctrl-Shift-Enter) but
it does not provide the correct results. It appears to be incrementing the
cell value row by row.
Is it possible to have the original Formula using SUMPRODUCT but EXCLUDE the
very LAST "Results" Row (of data) for the Specific Month & Year?
Original Formula:
=SUMPRODUCT((OFFSET(Results,0,3,,5)=F$23)*(MONTH(O FFSET(Results,0,1,,1))
=MONTH($B26))*(YEAR(OFFSET(Results,0,2,,1))=YEAR($ C26))*(OFFSET(Results,0,1,,
1)<""))
Further assistance most appreciated.
Cheers,
Sam
Bob Phillips wrote:
Here's an array formula
=SUM(--(OFFSET(Results,0,3,MAX(INDEX((MONTH(OFFSET(Result s,0,1,,1))=MONTH($B26))*(YEAR(OFFSET(Results,0,2,, 1))=YEAR($C26))*(ROW(Results)),0)-MIN(ROW(Results))),5)=$F$23))
as an array formula, commit it with Ctrl-Shift-Enter, not just Enter.
--
Message posted via
http://www.officekb.com