Thread: Find and Count Frequency of Numeric Value in Non-Contiguous Rows
View Single Post
  #3   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 Find and Count Frequency of Numeric Value in Non-Contiguous Rows
Hi Roger,

Thank you very much for your reply and assistance. Your Formula did the job.
Great!

=SUMPRODUCT((F118:BO226=60)*(MOD(ROW(F118:BO226)+ 2,3)=0))

Cheers,
Sam

Roger Govier wrote:
Hi Sam

Try
=SUMPRODUCT((F118:BO226=60)*(MOD(ROW(F118:BO226)+ 2,3)=0))

Hi All,

[quoted text clipped - 50 lines]
Thanks
Sam

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

Reply With QuoteReply With Quote