Re: averageif (XL2007)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Roger Govier" <roger@technology4unospamdotcodotuk>
Date: Fri, 5 Sep 2008 10:32:51 +0100

Hi Rob

Try
=averageif(A5:A350,">"&$A$2,B5:B350)
--
Regards
Roger Govier

"RobFJ" <rfj1001*delete*@ntlworld.com> wrote in message news:GP6wk.202718$Ft5.80603@xxxxxxxxxxxxxxxx

I'm trying to get an averageif formula working but the criterion I'm trying to satisfy is of a number greater than that contained in a specific cell.

=averageif(A5:A350,>$A$2,B5:B350)

I've tried all sorts of variants of syntax for the criterion with no success. The formula will work if I put a specific value in, eg ">4".

Can SKS help out.

Tx

Rob

Follow-Ups:
- Re: averageif (XL2007)
  - From: RobFJ

References:
- averageif (XL2007)
  - From: RobFJ

Prev by Date: Re: Combine 2 formulas
Next by Date: Re: Combine 2 formulas
Previous by thread: averageif (XL2007)
Next by thread: Re: averageif (XL2007)
Index(es):
- Date
- Thread

Relevant Pages

Sumproduct cell reference vs embedded "values"
... I have experimented with all sorts of different combinations and there is ... clearly some syntax issue that I am running afowl of or something I do not ... But when I try to embed the cell contents directly into the formula i.e. ...
(microsoft.public.excel.worksheet.functions)
Enter data in next available row
... What is the syntax for putting text entered in a userform(or cell or ... whatever) into the next available row in a sheet, ... database of sorts? ...
(microsoft.public.excel.misc)
Re: User Defined Function and VLookUP
... It is easy to see the formula even after applying protection as suggested ... Just copy a blank cell and then Edit> paste Special> Formats over ... , syntax wasn't working. ... "Jacob Skaria" wrote: ...
(microsoft.public.excel.worksheet.functions)
Re: Evolution of Separate Genders in Animals
... genetic material between organisms arose before the formation of ... separate genders, but did separate genders come before hermaphrodites ... those variants reproduce. ... nuclear and cell division with genome duplication. ...
(talk.origins)
Re: Re (2): Is gforth OOP serious ?
... class the primary extension is via class variables which are cell ... with a delimiter, and cut it back to the delimiter supplied by SUBWORD. ... It's A syntax. ...
(comp.lang.forth)