Forum Discussion
Solved
Countif function do not count correctly
I figure out that countif counts 1.20 as 1.1 It is possibleto find correct solution with "exact if and sum" formulas. you can find the excel file in the attachment.
6 Replies
your number is not format as number but as text i have sent you a solution you can check it if there is any problem so please clear your criteria for better understanding alparslan
Hi, Thanks for your reply. However my data is not actually an excel number. It is an identity. This list is a production BOM. Some identities have two or more points like 1.2.1 or 1.4.3.1
