May 03 2020 02:05 AM
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.
May 03 2020 03:08 AM
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
May 03 2020 03:53 AM
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
May 03 2020 04:00 AM
SolutionMay 03 2020 04:10 AM
May 03 2020 04:14 AM
Nope, the same here are 1.1 and 1.10 since COUNTIF converts texts which present numbers to numbers, if don't use CHAR(173).
With SUMPRODUCT() you don't need EXACT, it compares texts as they are. Just
=SUMPRODUCT(--($A$2:$A$21=A2))
is enough.
May 04 2020 02:34 AM
Thank you. It is less completed.
May 03 2020 04:00 AM
Solution