SUMIF Variations Problem

[andyp161]

Hi there,

I would like to develop variations of the SUMIF function. For example
in Column A are the names of consultants (Bob, Jim, Bill etc)and i
Column B are the types of businesses the consultants have mad
referrals to (Risk, Financial, Healthcare etc). Every time
consultant makes a referral, a new row is completed and, therefore, th
same consultant's name can appear numerous times. In a summary table,
would like to be able tell how many times each consultant has made
referral to each type of business ie Bob has made 2 referrals to Risk
1 referral to Healthcare and 7 referrals to Financial.

Many thanks

And

 

[Frank Kabel]

Hi
I would use a pivot table for this

 

[JulieD]

i agree with Frank
however, if you really want a formula solution then you can use the
SUMPRODUCT function
e.g.
=SUMPRODUCT((A1:A100="Bob")*(B1:B100="Risk"))
just remember with sumproduct the ranges must be the same size and you can't
use wildcards
etc

Cheers
JulieD

 

[andyp161]

Thanks Frank and Julie for your responses. Do you happen to know of
link to a good tutorial on pivot tables.

Kind regards

And

 

[JulieD]

Hi Andy

try
http://www.cpearson.com/excel/pivots.htm
and
http://peltiertech.com/Excel/Pivots/pivotstart.htm

to get you started

Cheers
JulieD