Thread: [Solved] count if function, Index and Match
View Single Post
 
Old 06-14-2024, 09:09 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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"}))
Reply With Quote