Count IF multiple criteria
Sean,
a few things wrong with your suggested formula - you can't use
wildcards like that, and your first "date" will be evaluated as 1
divided by 30 divided by 2008, so it's not going to work.
Pete
On Dec 11, 5:43*pm, Sean Timmons
wrote:
What you're looking for there is a sumproduct.
=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")))
=SUMPRODUCT(--('January- STD'!$C$7:$C269="*yhard*"),--('January-
STD'!$G$7:$G$269<=01/30/2008),--('January- STD'!$G$7:$G$26912/31/2007))
Will count all rows where the string yhard is found within column C and the
date in column g is from January 2008. Please note.... All ranges must be
equal, thus 7 - 269 in all 3 pieces. the -- makes each value either a 0 or a
1 based on if the cell matches the criterion. In the above, you MUST use a
range. Don't try using C:C, must be C7-C269 or some such...
HTH!
"Sarah Barah" 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! :)- Hide quoted text -
- Show quoted text -
|