ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using countif with multiple criteria (https://www.excelbanter.com/excel-worksheet-functions/447863-using-countif-multiple-criteria.html)

 mkz December 19th 12 06:02 PM

Using countif with multiple criteria

I have 2 worksheets i'm working in

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

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

On sheet1, I have a drop down list of months. I want to be able to pick a month, and then have it tell me if the payee in the same column has a 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 no luck. I'm thinking maybe it has to do with some of the criteria being listed in a row, others listed in a column??

Any help is appreciated! Thanks!

 Spencer101 December 19th 12 06:29 PM

Quote:
 Originally Posted by mkz (Post 1608131) I have 2 worksheets i'm working in Basically in sheet 2 I have a schedule of payees and which months they need to be paid in. Months are in row 1, payees in column A. Then there are x's in the months that that payee needs to be paid In sheet one, i have payees listed in a row, along with other info in rows below. Anyway, the point is payees are listed in row form in sheet1, as opposed to column form in sheet2. On sheet1, I have a drop down list of months. I want to be able to pick a month, and then have it tell me if the payee in the same column has a 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 no luck. I'm thinking maybe it has to do with some of the criteria being listed in a row, others listed in a column?? Any help is appreciated! Thanks!

Hi,

Any chance you could post an example workbook here or email it to me on pubnut @ gmail . com (without the spaces, obviously)?

It's far easier to help out if we can see the workbook itself.

S.

 mkz December 19th 12 06:33 PM

Quote:
 Originally Posted by Spencer101 (Post 1608132) Hi, Any chance you could post an example workbook here or email it to me on pubnut @ gmail . com (without the spaces, obviously)? It's far easier to help out if we can see the workbook itself. S.

Yes I'll email it - tried to upload it here but the file was too big

 Wilbur Chua July 19th 21 01:45 PM

Countifs

Hello! If you want to do a COUNTIF function in Excel with Multiple Criteria, you need to use the COUNTIFS Function in Excel.

Hope this helps!

 All times are GMT +1. The time now is 01:41 PM.