count a number of cells based on the beginning of a order number

		Microsoft Office Forums > Microsoft Excel > Excel
count a number of cells based on the beginning of a order number

08-06-2017, 08:54 PM

Kubi

Windows XP count a number of cells based on the beginning of a order number

Office XP

Advanced Beginner

Join Date: May 2017

Posts: 34

Haha sorry for posting this, i did try and delete. very easy to solve sorry.

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

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
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
How do I change the page number order?	officeboy09	Excel	4	10-30-2013 08:11 PM
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 04:32 AM.