COUNTIF when range is cells with formula

  • Thread starter Thread starter martialtiger
  • Start date Start date
M

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 :confused: . Thanks in advance for the help
 
Awesome! It worked. Any ideas why =COUNTIF(C4:C18,"<C24") doesn't work
by itself? Thanks again for the help! :D
 
Hi
"<C24" would be interpreted as string. So C24 would not be replaced by
the cell value.
Frank
 
Back
Top