N
Nebbez
Hi,
I am trying create a spreadsheet that will become a draft that I wil
use on a daily basis. Ive been trying for hours...
I would use this draft spreadsheet to copy pate a list of numbers an
have 4 averages computed given 4 criterias
My criterias are quartiles: Bottom 25%, the next 25%, the next 25%, an
the top 25%
And I would like the average of the numbers I will paste given thes
criterias.
What I did is compute the quartiles using the formula, then I tried t
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 le
me use this format for my criterias: "<30"... Which means I wil
manually type the formulas everytime I get my quartiles computed..
Im not sure if I was clear... Any tips
I am trying create a spreadsheet that will become a draft that I wil
use on a daily basis. Ive been trying for hours...
I would use this draft spreadsheet to copy pate a list of numbers an
have 4 averages computed given 4 criterias
My criterias are quartiles: Bottom 25%, the next 25%, the next 25%, an
the top 25%
And I would like the average of the numbers I will paste given thes
criterias.
What I did is compute the quartiles using the formula, then I tried t
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 le
me use this format for my criterias: "<30"... Which means I wil
manually type the formulas everytime I get my quartiles computed..
Im not sure if I was clear... Any tips