View Single Post
 
Old 04-25-2022, 09:57 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

It looks like you want to count your products, not to sum up something there!

Something like this must work for you:
Code:
=COUNTIFS($A$2:$A$100, "12345*")
for 1st one, etc.
In case you want to do this for all products in single go, you must have a table of products, and a column for product counts there - something like (on fly):
Code:
=COUNTIFS(YourSheet!$A$2:$A$100, $A2 & "*")
Reply With Quote