Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count IF multiple criteria
I hope someone can PLEASE help me :)
How do you get a countif to work within a countif's results? I want it to count how many cells within a range contain certain text and within the results of that I want it to tell me how many fall within a range of dates. This is to be reported on a seperate spreadsheet within the workbook so filtering isn't an option. I thought the below formula would work but it actually adds the count of cells that contain the text "yhard" with the count of cells that fall within the date range. =COUNTIF('January- STD'!$C$7:$C269,"*yhard*")+((COUNTIF('January- STD'!$G$9:$G$155,"<=01/30/2008")-COUNTIF($G$9:$G$155,"<01/01/2008"))) Is there a way to connect an AND and have the count ifs done in sequential order by connecting the following 2 formulas? #1 criteria =COUNTIF('January- STD'!$C$7:$C269,"*yhard*") # 2 criteria =COUNTIF('January- STD'!$G$9:$G$155,"<=01/30/2008")-COUNTIF('January- STD'!$G$9:$G$155,"<01/01/2008") Thank you thank you thank you in advance if there is a genious out there that can help me solve my problem! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
COUNT WITH MULTIPLE CRITERIA | Excel Worksheet Functions | |||
COUNT or SUM with multiple criteria | Excel Worksheet Functions | |||
I need to count while using multiple criteria | Excel Worksheet Functions |