• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countif Decimal Value

D

Dimple

New Member
Dear Consultant

Can you please assist me with the folloiwng request:
  • I am trying to count the number of times that the decimal value "0.01" appears together with the word "bread".
  • I have attached a sample data sheet for your reference.
I am unable to generate a result using multiple mthods including MOD and If statements.

Can you please assist.

Thank you

Best regards,

Dimple
 

Attachments

  • Countif + Decimal Value.xlsx
    8.7 KB · Views: 6
Hi Dimple ,

Your post and your data do not match ; your data has 3 occurrences of Bread , but the data in column A corresponding to these 3 entries is 1001.01 , 2001.01 and 3001.01 ; what is the result you want the formula to return ? When your data is having such values , why does your post mention 0.01 ?

Narayan
 
Hi Narayan,

I want to count the number of occurrances where the value in column A ends with a decimal of 0.01 AND the value in column B is "Bread".

Based on the data I have provided, this occurs on 3 occassions and hence the result i should obtian is 3

Hope this helps.

Dimple
 
Hi Dimple,

I know there will be some easy walkaround, but some how MOD function is not functioning in its usual way with floating numbers.

Try below formula:

=SUMPRODUCT((B2:B10="Bread")*(MID(A2:A10,SEARCH(".",A2:A10),255)+0=0.01))

Regards,
 
You must log in or register to reply here.
Back
Top