| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting specific number following decimal point in a row
Hi Everyone,
I have the following dataset 150.1 153.2 154.3 155.1 155.1 157.1 157.4 I would like to count how many cells have 0.1 given the condition that they are between those cells that start with 0.3 and end with 0.4 So in the above example the answer would be 3. I tried COUNTIF function but am having trouble. Can someone help? Thanks Cherian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| starts with decimal point only if number is like 0.###... | Excel Worksheet Functions | |||
| Number format still uses decimal point | New Users to Excel | |||
| Show decimal point only if not a whole number | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
Threaded Mode
