I am trying to count unique id's only and have used this formula

jcepon

I am trying to count unique id's only and have used this formula however, I am getting a blocked error and do not know how to fix it?

MoniqueM

Are are doing this in a cell or in the Sheet Summary section? What is your ID you are trying to count?

Try this =COUNTIF(br_id:br_id, ="jcepon") but replace the jcepon with what you are trying to look up. That is also assuming your column name is "br_id" yes?

I have used this one in the last when counting different "Status"s of jobs on a dashboard pie-chart: =COUNTIF(Status:Status, ="Requested")

The Status column is setup as a dropdown option with several project phases that periodical get changed.

jcepon

=COUNT(DISTINCT([br_id]:[br_id])) this is what I am using

MoniqueM

Are are doing this in a cell or in the Sheet Summary section? What is your ID you are trying to count?

Try this =COUNTIF(br_id:br_id, ="jcepon") but replace the jcepon with what you are trying to look up. That is also assuming your column name is "br_id" yes?

I have used this one in the last when counting different "Status"s of jobs on a dashboard pie-chart: =COUNTIF(Status:Status, ="Requested")

The Status column is setup as a dropdown option with several project phases that periodical get changed.

jcepon

the problem is that I have several duplicate id numbers and I only want to count the 1 unique number

384125

354717

335992

335992

335992

415429

415429

415429

381250

381250

381250

234110

234110

234110

234110

234110

379344

379344

379344

379344

MoniqueM

A few questions: What is your Column name? What is the Column properties set as?

MoniqueM

Don't judge my paint skills...

Try to see if you can change your column properties to Text/Number I used your original formula =COUNT(DISTINCT([BR_ID]:[BR_ID]))

jcepon

Text number br_id

jcepon

you mean because I have it in the primary column that is the problem?

MoniqueM

It should still work even as the Primary Column (default is Text/Number); the only thing I can think of is that the Sheet Summary properties has a unique format. For example if you have it set to Date or if you added a currency to it. I just tried it a few ways and it call comes up with "7"

EDIT @ 11:45am : Do you have the right permission level on the sheet?

jcepon

yes i am admin on sheet

jcepon

what I need is the total number of unique id's, when I move the BR ID to a column that is not primary it did remove the blocking. But the problem now is that I am getting a count of 1 instead of a total number of unique id's