Count IF multiple criteria
:)Thank you Pete from the UK! You are the winning genious! Your below
formula works... I dont really understand the ISNUMBER and SEARCH in terms of
how but as long as I get the correct answer I am happy. This saves me hours
upon hours of work. Thanks again!
"Pete_UK" wrote:
COUNTIF is limited to a single condition - if you have more, then you
can use SUMPRODUCT like this:
=SUMPRODUCT((ISNUMBER(SEARCH("yhard",'January- STD'!$C$7:$C269)))*
('January-
STD'!$G$7:$G$269<=--"01/30/2008")*('January-
STD'!$G$7:$G$269--"01/01/2008"))
Hope this helps.
Pete
On Dec 11, 4:53 pm, Sarah Barah <Sarah
wrote:
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! :)
|