#### inharmony222

##### New Member

- Joined
- Sep 19, 2019

- Messages
- 4

I am just starting to learn formulas in Excel. I have created a "count if" formula looking at multiple columns but I need to exclude duplicate rows based on a value (being a number) listed in column A.

My current formula looks like this: =COUNTIFS(E2:E1000,"NO",H2:H1000,"NOTIFICATION")

How can I add in a way to make it only count one of any # in column A that have a duplicate #.

Oh, I have also added conditional formatting already to column A so it formats color fill to any duplicates after the first, if that helps with a formula.

Thanks!