Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Limited Ceiling Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Rotate table using 1 formula ADDRESS
  • CONVERT function CONVERT
  • 0% interest promotion Basic Math
  • Insert Blank rows into table using functions CHAR
  • Return 12 values in one number AND
  • Blank (isempty) VS “” (null string) Excel User tips

Sum of divide – Array formula

Posted on January 24, 2012 By ANmar No Comments on Sum of divide – Array formula

This is the answer to an old question:

Here is the story behind it:

I had a client who calls me every now and then asking the same question:

” Can you please remind me of how I would use an array formula? you know, enter multiple conditions into one SUM function? ”

Then I go a head and show him the procedure and the result, most of the time he uses phone, so I have to take him with the steps needed.

Now after these years, I found the xls file in my library, thought it is going to be good to share it here.

It is the one that divide then Sum the totals into one cell (which uses array formula to do that)

Formulas used here are:

=SUM(C7:C18/D7:D18)

In cell G7 (Remember to press CTRL+SHIFT+Enter after pasting to apply the Array formula)

Above formula is equivalent to two formulas, one in column J:

=C7/D7

And another one in cell K7

=SUM(J:J)

 

Array formula, Basic Math, Standard functions, SUM

Post navigation

Previous Post: Standard math to calculate Aspect Ratio
Next Post: CamelCase to Camel Case

Related Posts

  • 6174 Kaprekar’s constant Basic Math
  • CamelCase to Camel Case CHAR
  • Validation based on another Validation COUNTA
  • MID + SEARCH to convert cell to rows MID
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • The Excel “&” bug Excel User tips

Leave a Reply Cancel reply

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

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Multiple Dual-Validations COUNTA
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Always get 1st name (or last) Formulas - combined functions
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Pixel Excel Drawing Format Cells
  • Excel ad from early 90s Non-functions
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme