Help Counting Cells

rdwng1975

New Member
Joined
Dec 11, 2009
Messages
4
I have data in Excel that row by row represents a delivery stop by one of our trucks. Each row has customer name, address, invoice number, and billing and shipping account numbers. I am trying to find a way to have Excel recognize duplicate addresses, count them, and total. I am a newbie. This total count would represent how many times we have have stopped at that customer. Any ideas?
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Welcome to the board..

That sounds like Countif...

Say column A is the list of all the addresses for each stop.

In B1 (or whatever column is available) put the formula

=COUNTIF(A:A,A1)
And fill that formula down to the end of the data.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,216
Office Version
  1. 365
Platform
  1. Windows
You might also want to look at using a pivot table.:)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,405
Messages
5,595,947
Members
414,034
Latest member
torreyanderson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top