Forum Discussion
Solved
COUNT ID Codes IF Columns A & B respect specific criteria
Hello there! I'm working on a table, and I need to count the number of ID Codes depending on 2 specific criteria: 1) Each ID Code has to be counted only once, while as you can see from the ID Cod...
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.
antotom98 Perhaps like in the attached file?
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?