LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default Total A Range

I have a list of over 3000 people that bought products in different zip codes.

The spreadsheet is set up like below:

30044 1
30044 1
30125 1
11253 1

Th first numbers are the zip code and in the cell next to it, the number 1
represents a boought product in that zip code. Being that I have a list of
over 3000, how can I make a function that will total up how many products
were sold in each zip code???

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding 'total' in range excel Excel Worksheet Functions 3 March 19th 07 10:34 AM
how to get a total to add up a range andyhofer Excel Worksheet Functions 1 March 27th 06 07:47 PM
finding a range of dates to total Danbmarine Excel Discussion (Misc queries) 4 January 27th 06 09:28 PM
Searching a range of numbers for a specified total saustin Excel Worksheet Functions 2 January 19th 06 03:59 PM
How do I get the total of a range of cells that are in another she alice Excel Discussion (Misc queries) 1 November 24th 05 02:23 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"