Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 19th 12, 06:02 PM
mkz mkz is offline
Junior Member
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 3
Default 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!

Last edited by mkz : December 19th 12 at 06:07 PM

  #2   Report Post  
Old December 19th 12, 06:29 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by mkz View Post
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.
  #3   Report Post  
Old December 19th 12, 06:33 PM
mkz mkz is offline
Junior Member
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 3
Default

Quote:
Originally Posted by Spencer101 View Post
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nesting COUNTIF for multiple criteria in multiple columns NeedExcelHelp07 Excel Worksheet Functions 1 December 12th 07 05:47 PM
countif using multiple criteria Marcusdmc Excel Programming 2 September 24th 07 08:17 PM
Using Countif with multiple criteria JustLearning Excel Worksheet Functions 1 August 3rd 06 09:30 PM
COUNTIF - Multiple Criteria Uggywuggy Excel Worksheet Functions 6 July 12th 06 09:11 AM
COUNTIF Multiple Criteria Lori Hornick Excel Programming 1 March 22nd 05 04:56 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017