Re: SumIF and STDEVIF is there a such thing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks for the posts. I had already taken into account for blank cells in a
prior formula.

Tom, Once again you have solved my problem.

Chris

"Tom Ogilvy" wrote:

> {=STDEV(IF($F$3:$F$25=$F35,IF(ISNUMBER(H$3:H$25),(H$3:H$25))))}
>
> --
> Regards,
> Tom Ogilvy
>
> "Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:EC2AF7D4-9039-4302-9239-6C4990BE333F@xxxxxxxxxxxxxxxx
> > Hey guys,
> >
> > I am working on a spread*** that I have some arrays with SumIF and
> > CountIF. I am looking for a way to do a Standard Deviation through an
> > STDEVIF. I built the following formula, but Excel did not like it one
> bit.
> >
> > {=STDEV(IF($F$3:$F$25=$F35,IF(ISNUMBER(H$3:H$25)*(H$3:H$25),0)))}
> >
> > If I can not do a STDEV IF. Then I thought maybe I could perform a
> CountIF
> > in cell H36 and then try to perform an offset type of formula to tell
> Excel
> > which cells I would want the STDEV performed on. When I tried this:
> > STDEV(h36,x) I do not get the correct answer either. Essentially I was
> > thinking by using multiple countIF's I could perform a STDEV calc.
> >
> > Let me know your thoughts.
> >
> > thanks.
> >
> > Chris
> >
> >
>
>
>
.

Quantcast