count if function, Index and Match
Thank you for your quick response. I created the table and got the Countifs to work to with one product.
When I try with more than one product it is not working. Named the Table February.
=COUNTIFS(February[Product], "Unsecured", February[Product], "Secured")
In column B on worksheet Sheet1, I cannot get the total number for Unsecured and secured
Unsecured and Secured should be counting from Column B in the Data Worksheet.
=SUMIFS(February[Risk Level], February[Product], "Unsecured")
|