Countif Two Text Conditions

[Alexander_Read]

Hi

I know that countif questions are amongst the most common, but I have searched for an answer and still can't work it out.

I have a column with a list of employers(A) and in col B they show if they get paid weekly or monthly.

A B
Alex M
Alex M
Alex W
John W
Paul M
Paul M
Paul M
Paul W
Sipho W

I want a formula to count how many times Paul pays people monthly (M).
I.e. 3.
So it should look like this:
A B C
Person Monthly(M) Weekly (w)
Alex 2 3
John 0 1
Paul 3 1
Sipho 0 1

I use an autofilter to remove the duplicate names.

Any ideas what countif,dcounta, or array forumla I can use to do this?

Regards

Alex

[BigBas]

Try:

Please Login or Register  to view this content.

Obviously, adjust the ranges to suit.

[no dice]

A pivot table would be very fast and powerful in a situation like this and will accomodate data changes within your spreadsheet. Attached is a quick & dirty table based on the data in your Paysheet report file.

Your post example and the spreadsheet data didn't match so I assumed Calvin Bowles to be Paul. I also deleted a couple hundred rows of data because when I added the pivot table the size grew above upload limits.

[Alexander_Read]

Thanks Bigbas, I used your formula and it works fantastically!

[Alexander_Read]

Hi

What does this mean "(--" in a function?

Can you explain how the sumproduct formula is working and the logic behind it?

Regards

Alex

[arthurbr]

Hi,
this site will provide a nice explanation

HTH