Adding to conditions to a formula

AGM

I am trying to utilize the COUNTIFS function to combine two rows to eliminate blank fields. I have come up with the below formula.

=COUNTIFS({CBA - Master Range 1}, =Title@row, IF({CBA - Master Range 4}, NOT(BLANK)))

PLEASE HELP!

Paul Newcome

Try this:

=COUNTIFS({CBA - Master Range 1}, @cell = Title@row, {CBA - Master Range 4}, @cell <> "")

Paul Newcome

Try this:

=COUNTIFS({CBA - Master Range 1}, @cell = Title@row, {CBA - Master Range 4}, @cell <> "")

AGM

Thanks you... This worked!

What if I needed to remove duplicates within the row?

Paul Newcome

You would need a COUNT/DISTINCT/COLLECT combo.

=COUNT(DISCTINCT(COLLECT({CBA - Master Range 1}, {CBA - Master Range 1}, @cell = Title@row, {CBA - Master Range 4}, @cell <> "")))

AGM

Not having any luck with that one.

Paul Newcome

Are you able to provide screenshots for reference and expand on where exactly the duplicates are that you want to exclude? Knowing exactly what your ranges cover would also be helpful.

AGM

If there is an opportunity to meet and discuss over a virtual platform, would be great. You could email me at antonio_gonzalez-martinez@uhc.com and I can send out an invite.

Thanks!