Adding like items from data filter

**michaelk68** · 09-04-2008, 10:17 AM

Hello, First time Poster here..

I am working with a large file, filtered by unique org.
How can I tally up totals corresponding to said orgs.

Example

In the spreadsheet, ABC Corp has 37 entries, each with a numerical "product uses" field. How can I quickly get a total of each distinct organizations total uses ?

**NBVC** · 09-04-2008, 10:21 AM

If you already have a list of the unique organizations, then you can use Countif() to count number of entries.. see Countif in Excel help files...

Otherwise, you can create a pivot table that collects unique organizations and gives corresponding values...