CountIf or another function

S

SBO

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
 
S

Stefi

Being the table in Sheet1
and the result table in Sheet2
Enter this formula in B2 of Sheet2 and fill it to the right and down:
=SUMPRODUCT(--(Sheet1!$A$2:$A$5=$A2),--(Sheet1!$B$2:$B$5=B$1))
Adjust ranges to real data!

Regards,
Stefi

„SBO†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(AND)Etc..... 3
Count with 1 variable & 1 constant criteria formula 3
using CountIF function or Array? 3
COUNTIF greater than one column and less than another 5
Can I use COUNTIF for 2 separate IF queries? 5
Counting Closed Date < 2 weeks of Open Date etc 0
Sum of Cells if Row Contains a Specific Variable 3
Excel Countif Function - Calculating Between Two Sets of Values 3

Top