View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] surajcherian@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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