Solved: countifs, multiple ranges - excel

[allison]

I'm sure that there is a better way to get done what I am trying to accomplish.....and I'm hoping that someone can help me out.

Detail worksheet has a date column and a justified? column (yes and no are the values in the cells).

I am trying to create a summary sheet by month. The summary is the total entries for the month and of that total, the number that were justified.

The total entries by month is being accomplished by this:
COUNTIF(Detailrange,monthname)

I can not figure out how to get count the yeses in the justified column only for entries entered that month. What I want is:
If date is january, count the "yes"es

I can count all of the yeses, I can count all of the January records - I just don't know how to combine them to get my desired end result.

Any suggestions.

[Bob Phillips]

=SUMPRODUCT(--(MONTH(Detailrange)=MonthNum),--(JustifiedRange="yes"))

[allison]

Fantastic!

I saw a post from you using SUMPRODUCT before, but wasn't sure if that was what I should do.

Very much appreciate the help!!

[mdmackillop]

For more on SumProduct (http://www.xldynamic.com/source/xld.SUMPRODUCT.html)

[Bob Phillips]

That's a good page :whistle: