View Single Post
 
Old 04-25-2022, 09:57 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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