Hi,

You may also want to try pivot tables

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"SBO" wrote in message
...
Hi,

Here is the data in my spreadsheet

ColumnA ColumnB

Open Jack
Open Robert
Closed Jack
In Progress Edward


I want to get a count of all Open, Closed and In Progress, but for each
individual. The output would be as follows and the formula must be
contained
in a single cell:

Jack Robert
Edward
Open # #
#
Closed # #
#
In Progress # #
#

The CountIf works for me in terms of counting instances in a single
column,
but I want to add an "AND" relationship to it and account for Column B.

Thank you,

SB