Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page count a number of cells based on the beginning of a order number count a number of cells based on the beginning of a order number
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2017, 06:16 PM
Kubi Kubi is offline count a number of cells based on the beginning of a order number Windows XP count a number of cells based on the beginning of a order number Office XP
Advanced Beginner
count a number of cells based on the beginning of a order number 		 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default count a number of cells based on the beginning of a order number
I want to sum the number of products sold based on the different customers, or though the order numbers change the reference at the beginning of them does not.

.i.e

Wellington, SW-003342

Auckland, SP-002241

Christchurch, SO-254985659

NZ, SK-004571

North Island, SB-520884




there will be multiple orders from each area so i want to have a cell that will count all the lines with SB,SK,SO,SP,SW in them.
Attached Files
File Type: xlsx online test.xlsx (11.3 KB, 10 views)
Reply With Quote
  #2  
Old 08-06-2017, 08:39 PM
macropod's Avatar
macropod macropod is offline count a number of cells based on the beginning of a order number Windows 7 64bit count a number of cells based on the beginning of a order number Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
If you put the codes in H25 to H29, you could use this array formula in I25:
=SUM(IF(LEFT(H$1:H$23,2)=H25,I$1:I$23,0))
then copy the formula down to I29.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-06-2017, 08:54 PM
Kubi Kubi is offline count a number of cells based on the beginning of a order number Windows XP count a number of cells based on the beginning of a order number Office XP
Advanced Beginner
count a number of cells based on the beginning of a order number 		 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default
Haha sorry for posting this, i did try and delete. very easy to solve sorry.

just used =SUMIF(A:A,"*SO*",B:B)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting to color cells based on number kallard Excel 4 12-26-2016 11:10 AM
count a number of cells based on the beginning of a order number I want to know how to format a sentence after beginning it with an automatic number spirituel Word 2 09-29-2015 01:50 AM
count a number of cells based on the beginning of a order number How do I change the page number order? officeboy09 Excel 4 10-30-2013 08:11 PM
count a number of cells based on the beginning of a order number How can I count cells based on their fill color that was set by conditional format trueimage Excel Programming 1 10-25-2013 12:08 PM
chronological order number needs to be changed as ndash sajeev Word 0 09-15-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft