Average given criteria, HELP!

[Nebbez]

Hi,

I am trying create a spreadsheet that will become a draft that I will
use on a daily basis. Ive been trying for hours...

I would use this draft spreadsheet to copy pate a list of numbers and
have 4 averages computed given 4 criterias

My criterias are quartiles: Bottom 25%, the next 25%, the next 25%, and
the top 25%

And I would like the average of the numbers I will paste given these
criterias.

What I did is compute the quartiles using the formula, then I tried to
use the =sum.if formula and the =count.if to compute my average

The problem is, excel will not let me input a criteria in this format:
"<H3" (H3 is where my lowest quartile is). Rather excel will only let
me use this format for my criterias: "<30"... Which means I will
manually type the formulas everytime I get my quartiles computed..

Im not sure if I was clear... Any tips?


--
Nebbez

[B. R.Ramachandran]

Hi,

The format should be "<"&H3 (not "<H3") in the SUMIF and COUNTIF formulas.

Regards,
B. R. Ramachandran

"Nebbez" wrote:

>
> Hi,
>
> I am trying create a spreadsheet that will become a draft that I will
> use on a daily basis. Ive been trying for hours...
>
> I would use this draft spreadsheet to copy pate a list of numbers and
> have 4 averages computed given 4 criterias
>
> My criterias are quartiles: Bottom 25%, the next 25%, the next 25%, and
> the top 25%
>
> And I would like the average of the numbers I will paste given these
> criterias.
>
> What I did is compute the quartiles using the formula, then I tried to
> use the =sum.if formula and the =count.if to compute my average
>
> The problem is, excel will not let me input a criteria in this format:
> "<H3" (H3 is where my lowest quartile is). Rather excel will only let
> me use this format for my criterias: "<30"... Which means I will
> manually type the formulas everytime I get my quartiles computed..
>
> Im not sure if I was clear... Any tips?
>
>
> --
> Nebbez
>