You could use the SUMPRODUCT formula to help you with this.

Assume that Sheet1!Column A is greeting and Sheet1!Column D is the
persons name

Setup a similar table on Sheet2 but with only one row per person rather
than multiple and it would be something like this...

=SUMPRODUCT(--(Sheet1!$A:$A=0),--(Sheet1!$D:$D=$D2))

That should return the count of all '0' for greeting for the person in
D2. You can copy and paste that formula down for each person and
category and get the results.

While it won't give you
Greeting
Transfer
Greeting
Greeting

It will give you

Greeting Transfer Name
3 1 Smith
2 0 Jones


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=543319