Prev: Additional column formula in pivot table
Next: How do I keep rows a1-a2 always at top of screen when on row 50
From: Rene on 27 May 2010 19:57
Trying to average the results of this sumproduct formula. Searched the
questions already asked but only found average if for 1 or 2 criteria

SUMPRODUCT(--(S498:S534="A"),--(G498:G534>=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="A"),--(G498:G534<>""))
From: T. Valko on 27 May 2010 21:49
See your other post

--
Biff
Microsoft Excel MVP


"Rene" <Rene(a)discussions.microsoft.com> wrote in message
news:3626EFB0-1CEA-4201-B0EB-473C0A3C7293(a)microsoft.com...
> Trying to average the results of this sumproduct formula. Searched the
> questions already asked but only found average if for 1 or 2 criteria
>
> SUMPRODUCT(--(S498:S534="A"),--(G498:G534>=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="A"),--(G498:G534<>""))


 | 
Pages: 1
Prev: Additional column formula in pivot table
Next: How do I keep rows a1-a2 always at top of screen when on row 50