Thread: Sum Count of Numeric Criterion for LAST 5 Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com
 
Posts: n/a
Default Sum Count of Numeric Criterion for LAST 5 Rows
Hi All,

I would like a Formula that uses an Input cell (to accommodate changing
Numeric Criterion) Summing the Count of a Numeric Criterion in the LAST 5
Rows of a Dynamic Named Range "Data". Named Range "Data" spans 8 Columns and
many Rows.

Thanks
Sam

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote