Quote:
Originally Posted by p45cal
Code:
=COUNTIFS(February[Product], "Unsecured")
or if you're looking to count more than one product, maybe along the lines of:
Code:
=SUM(COUNTIFS(February[Product], {"Unsecured","Secured"}))
|
Thank you. It worked to count more than one criteria.
=SUM(COUNTIFS(February[Product], {"Unsecured","Secured"}))
I just need to count the product field and then total what is in Risk Level column on data sheet. I need a count based on Product.