count if function, Index and Match

Alaska1 · #5 06-14-2024, 10:02 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Match & Index function	chelsea92	Excel	4	03-24-2023 04:26 AM
Index and Match Function	mismag	Excel	5	05-29-2019 11:26 AM
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Index Match Function across different worksheets	shay_mt	Excel	2	04-27-2015 06:04 AM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM