View Single Post
 
Old 08-06-2017, 06:16 PM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
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, 12 views)
Reply With Quote