CountIf or another function

  • Thread starter Thread starter SBO
  • Start date Start date
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
 
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
How to search and replace cells 0
Sum of Cells if Row Contains a Specific Variable 3
countifs Function not giving desired result with date criteria 2
using CountIF function or Array? 3
COUNTIF not including something in both columns 2
COUNTIF Function 4
COUNTIF with Dates 3

Back
Top