Forum Discussion
COUNT ID Codes IF Columns A & B respect specific criteria
What should your answer be in this example?
Perhaps this:
=COUNT(UNIQUE(FILTER(Table1[ID Code],Table1[Balance in $USD]<>0)))
It will return 12.
Hello Riny_van_Eekelen
Thanks a lot for your reply! That works, but I'm actually trying to do it with just one formula. Are you aware of any formula that might perform that?
Revised it to an all-in-one formula using HSTACK, BYROW and LAMBDA. See it that works for you.
- Thanks a lot for that!
Would eventually be possible to get the final total number in just one cell?Not sure I follow. Perhaps I misunderstood you completely. If the Final Total equals 14, we could just count all the non-zeroes in the USD column.
=COUNTIF(Table1[Balance in $USD],"<>0")
Or else, what total would you expect to see from your example data?
Riny_van_Eekelen sorry for the misunderstanding, actually I should have explained myself better. I just need to fill the bottom table in a dashboard, and I was trying to build a unique formula that gives me the result taking into account the parameters reported above.
ID Code Balance in $USD 2476275379 35,268,847,385.00 5207551055 205,721,030.00 9359515808 91,720,392,066.00 2476275379 38,491,785,509.00 3967032414 42,833,118,004.00 8663489462 0.00 4931997212 67,749,503,521.00 2951917685 23,981,235,402.00 2830183998 64,626,847,523.00 1005553923 94,602,840,726.00 2374653231 0.00 7478040492 88,095,379,658.00 1005553923 28,086,717,554.00 9488876464 78,954,674,545.00 7980868034 81,063,980,379.00 8428446508 48,394,944,086.00 SUMMARY TABLE Total number of ID Codes ?