I got it:

=IF(COUNTIF('Quarter 1 Data'!$G$4:$G$500,"Courtney"),AVERAGE(IF('Quarter 1
Data'!$G$4:$G$500="Courtney",'Quarter 1 Data'!$C$4:$C$500)),"")

=IF(COUNTIF('Quarter 1 Data'!$F$4:$F$500,"TP"),AVERAGE(IF('Quarter 1
Data'!$F$4:$F$500="TP",'Quarter 1 Data'!$C$4:$C$500)),"")


Thanks everyone for the combined help. I do have another #DIV/0! error
question, but I'll post in a new message to close this thread!

Dan


"Dan the Man" wrote:

I'm getting further along. The formula below works per Harlan's suggestion,
and removes occurrences of the #DIV/0! error. It now places FALSE in the cell
when no instances of Allen exisit:

=IF(COUNTIF('Quarter 1 Data'!$G$4:$G$500,"Allen"),AVERAGE(IF('Quarter 1
Data'!$G$4:$G$500="Allen",'Quarter 1 Data'!$C$4:$C$500)))

As opposed to FALSE showing up when there are no instances of Allen in the G
Range, can the cell just stay blank? That would be ideal?

In addition, I'd like to be able to do the same thing with the second
formula to avoid the #DIV/0! error. Below is an example of the current
formula which works when data is input into the F Range, but leaves the
#DIV/0! error when it is not:

=AVERAGE(IF('Quarter 1 Data'!$F$4:$F$500="ARC",'Quarter 1 Data'!$C$4:$C$500))

Thanks,

Dan



"Harlan Grove" wrote:

"Bob Phillips" wrote...
....
As an aside, it can be sllightly shortened

=IF(COUNTIF('Quarter 1 Data'!$G$4:$G$500,"Allen"),
AVERAGE(IF('Quarter 1 Data'!$G$4:$G$500="Allen",
'Quarter 1 Data'!$C$4:$C$500)))
....

Only if you want to see FALSE when there are no instances of Allen in
the G range.