Hi,

On my sheet I have a series of countifs functions. The last one I need (L2) is to count three Criterias (Within a date range (Violations A:A), the level it falls in (Violations K:K), and inspections number (Violations C:C)) The inspection numbers however duplicate and I only want to count them once.

Help please!

Nothing drives me more crazy than when i get to the last part of a function and i cant figure it out!
Book1 revised.xlsx
Thanks so very much