Count long numbers without COUNTIF in Excel
This tutorial shows how to Count long numbers without COUNTIF in Excel using the example below; Formula =SUMPRODUCT(–(A:A=A1)) Explanation This is an annoyingly long introduction, but the context is important, sorry! If you try to count very long numbers (16+ digits) in a range with COUNTIF, you may see incorrect results, due to a bug …