count the number of text in a cell based off a different cells text

Kubi · #1 08-23-2017, 04:23 PM

I have a list that shows all completed orders and who has completed them, I need to get a total of how many orders each person has completed for each customer.

I can work it out to give me the total of orders for each person but I cannot break that down to customers as well.

This information will then be placed into various charts that will update as soon as i paste in the new information for each day.

xor · #2 08-24-2017, 09:10 AM

Is it something like the attached?

Kubi · #3 08-24-2017, 01:23 PM

that Defiantly works at giving me the total orders pick thank you.

I would also like to know how I would go about making a list of the customers and then next to that have it will show who has picked those orders and how many?

xor · #4 08-24-2017, 05:00 PM

Use a pivot table

Kubi · #5 08-24-2017, 05:53 PM

Awsome thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count a number of cells based on the beginning of a order number	Kubi	Excel	2	08-06-2017 08:54 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Formula, Compare two cell's text and based on results output a number	Offrddrver	Excel	4	03-23-2016 11:32 PM
Header must toggle text & color + show count of conditionally formatted cells below	Franktoon	Excel	3	02-18-2014 02:10 PM
How to count the total cells that contains text data?	Learner7	Excel	1	06-30-2011 04:13 PM