Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i'm assuming COUNTIF is function i need to use, however, if there is better
way i'm all ears. have row of values and would like to be able to count number of values which are a multiple of three, i.e. if i have row of numbers from 1 to 9, formula would return 3; numbers 1 to 10, returns 3, numbers 1 to 11, 3; numbers 1 to 12, returns a 4. the number of values will vary and not be contiguous but will/can be in ascending order. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup multiples | Excel Worksheet Functions | |||
Multiples of 1000 in cells? | Excel Discussion (Misc queries) | |||
MULTIPLE LOOKUPS FOR MULTIPLES | Excel Discussion (Misc queries) | |||
Rounding to Multiples of Integers? | Excel Discussion (Misc queries) | |||
Multiples of 4 in an IF statement | Excel Worksheet Functions |