# Distinct Count of 4th Field Added to Formula Pulling 3 Fields

Options
edited 07/06/21

I need a distinct count of a fourth field added to this formula which is a combination of pulling three fields:

=COUNTIFS([Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)

With the three three fields being: Price Sheet Deadline (by month), Price Sheet Status, and if account was renewed=yes.

And I want to add a distinct count of a fourth field called Price Sheets. How would I fit this into the above formula? I tried this but it didn't work:

=COUNTIFS(DISTINCT(COLLECT([Price Sheet]:[Price Sheet},[Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1))

• ✭✭✭✭✭✭
Options

=COUNT(DISTINCT(COLLECT([Price Sheet]:[Price Sheet],[Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)))

• ✭✭✭✭✭✭
Options

do you have a column [price sheet] in your sheet?

• ✭✭✭✭✭✭
Options

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

=COUNT(DISTINCT(COLLECT([Price Sheet]:[Price Sheet],[Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)))

• ✭✭✭✭✭✭
Options

See below I added an @cell reference. Should fix it.

=COUNT(DISTINCT(COLLECT([Price Sheet]:[Price Sheet], [Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], @cell = "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)))

• Options

Hi @Leibel S this formula was also unparseable. It appears the same as the first one pasted too. Are you sure it was changed?

• ✭✭✭✭✭✭