View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJFry PJFry is offline
external usenet poster
 
Posts: 143
Default 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.