| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and count occurrances | Excel Discussion (Misc queries) | |||
| Can't find topic for count | Excel Discussion (Misc queries) | |||
| Count the number of rows where more than one column meets set crit | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Find the number of rows returned in a filter | Excel Discussion (Misc queries) | |||
Threaded Mode
