Using countif with multiple criteria

M

mkz

I have 2 worksheets i'm working i

Basically in sheet 2 I have a schedule of payees and which months the
need to be paid in. Months are in row 1, payees in column A. Then ther
are x's in the months that that payee needs to be pai

In sheet one, i have payees listed in a row, along with other info i
rows below. Anyway, the point is payees are listed in row form i
sheet1, as opposed to column form in sheet2

On sheet1, I have a drop down list of months. I want to be able to pic
a month, and then have it tell me if the payee in the same column has
payment due that month or not. Preferably, it would output a "Yes/No"
but it would also be fine/probably easier to have it output "1/0

I've tried various counts and sumproducts and array formulas, but n
luck. I'm thinking maybe it has to do with some of the criteria bein
listed in a row, others listed in a column?

Any help is appreciated! Thanks
 

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

Top