Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • BMI Calculator Basic Math
  • Jan8 date format AND
  • Paste Special Percentage Excel User tips
  • Cuts string of list of items Formulas - combined functions
  • Return 12 values in one number AND
  • Spreadsheet Compare application Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Get monthly total from table with dates DATE

Calculate above and below me

Posted on April 9, 2026 By ANmar No Comments on Calculate above and below me

Calculating average of the column in a cell inside that same column

Getting average of what is above me and what is below me in my same column in one of the cells

DS2 has 1 to use as Average, anything else to get regular number from some calculation …

PH2 = IF($DS2=1, IFERROR(AVERAGE(PH$1:PH1,PH3:PH$110),"N/A"), "Other numbers")

This is mainly to avoid circular references when using Average(A:A)

Average, IF, IFERROR, Logical, Standard functions, Statistical Tags:AVERAGE, IF, IFERROR

Post navigation

Previous Post: Stale values (Scratched functions)

Related Posts

  • Limited Ceiling Basic Math
  • Get 3rd Wednesday of month Basic Math
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Progress bar in pure functions CHAR
  • BMI Calculator Basic Math
  • Workdays – Across months DATE

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Sorting with functions only CHOOSE
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Searching table in 2 dimensions. Formulas - combined functions
  • CONVERT function CONVERT
  • Hyperlink usage and HyperlinkOf UDF CELL
  • New function IFERROR, finally IFERROR
  • CamelCase to Camel Case CHAR
  • Excel ad from early 90s Non-functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme