COUNTIF when range is cells with formula

[martialtiger]

Hey Everyone,

I'm running into a problem. I am running a dept average sheet for 1
categories. Under each column (categories), I want to count how man
averages are below the dept average. Here's how my spreadsheet is lai
out.

C4:C18 is where each rep's value is located. But in these cells th
values are pulled via formula on a different sheet within the sam
workbook.

Now on C23 I have the department average by using the average formul
with the values from C4:C18.

I'm trying to coun how many of the cells in range C4:C18 are below th
value found in C23.

Hope this makes since . Thanks in advance for the help

 

[Frank Kabel]

Hi

[snip]

I'm trying to coun how many of the cells in range C4:C18 are below the
value found in C23.

try
=COUNTIF(C4:C18;"<" & C23)

HTH
Frank

 

[martialtiger]

Awesome! It worked. Any ideas why =COUNTIF(C4:C18,"<C24") doesn't work
by itself? Thanks again for the help!

 

[Frank Kabel]

Hi
"<C24" would be interpreted as string. So C24 would not be replaced by
the cell value.
Frank