Count If trouble
You should be able to use SUMPRODUCT for this:
=SUMPRODUCT(($A$1:$A$11="PJ")*($B$1:$B$11="<30"))
You may need a seperate column that calculates the <30, etc. I am sure
there is a way to bake it into the formula, but let's see if this works first.
If you set up a summary table for each:
PJ <30 Formula
PJ <60 Formula
PJ <90 Formula
PJ 90 Formula
and so on. If you have a large number of records, this could get
problematic.
If you are using Excel 2007 you can use COUNTIFS().
Post back with questions.
--
Regards,
PJ
Please rate this post using the vote buttons if it was helpful.
"Jennnifer" wrote:
I'm trying to count the number of "late" occurrences by a persons name that
fall within a 90 , <90, <60, <30 wondow.
So there's 2 conditions, the persons name and the number of occurrences
within a sspecific range.
|