count if function, Index and Match

		Microsoft Office Forums > Microsoft Excel > Excel
count if function, Index and Match

06-14-2024, 09:09 AM

p45cal

Windows 10 count if function, Index and Match

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

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"}))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 AM.