Thread: SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year)
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
  
Posts: 247
Default SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year)
Hi Bob,

I've posted a new thread "SUMPRODUCT - (amended) Exclude LAST Row of Matched
Criteria (Month & Year)". Hope you can have a look. Apologies for my
confusion in the original post.

Cheers,
Sam

Bob Phillips wrote:
That is what that formula does, it ignores the last row for the date. If the
last row has no 11s I get the same result as Domenic got, if it contains 11s
these are ignored.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1

Reply With QuoteReply With Quote