Help with a Sumproduct or Countdiff

  • Thread starter Thread starter rjkulesa
  • Start date Start date
R

rjkulesa

I'm a user of these two array functions, but I'm in a big quandry right
now. Here is sample worksheet with the following labels: ColA =
Project, ColB =Business, ColC=Segment

ColA ColB ColC
1 31 Corp General
2 31 Corp General
3 40 Travel Privacy
4 21 Estate Privacy
5 21 Estate Privacy
6 18 Corp Application
7 18 Corp Application
8 6 Travel General
9 33 Corp General
10 33 Corp General

Based on Business and Segment, I would like to write a formula that
would count the distinct number of projects...
For example .... Based on project numbers, there have been '2' Corp &
General projects. There have been '1' Corp & Application projects, '1'
Travel & Privacy, '1' Travel & General, '1' Estate and Privacy. The
tables I am trying to populate would look like this when completed:

Corp Estate
Travel
General 2 Privacy 1
General 1
Application 1
Privacy 1

All of the table will be hand typed-in, I am looking for a formula to
return the numerical results.... Any ideas? Please Help
 
You really should take a look at Pivot tables - they would do this in a
heartbeat. They are one of the most powerful features Excel has, and yet are so
simple to get a handle on, especially when you take a look at Debra Dalgelish's
quickstart guide to using them:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm

I honestly can't stress enough how much work a Pivot table can save you in
analysing this kind of data.
 
Back
Top