Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CTRL+Y a mini macro Excel User tips
  • Formula Beautifier Excel User tips
  • Hello world! Uncategorized
  • Filter. Google Sheets function Google Sheets
  • SimpleANBox Basic Math
  • Zipcode-State search Formulas - combined functions
  • Pixel Excel Drawing Format Cells
  • Get 3rd Wednesday of month Basic Math

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
  • Unix DateTime Number Basic Math
  • Insert Blank rows into table using functions CHAR
  • Custom fiscal year calendar (CFlex) Basic Math
  • CamelCase to Camel Case CHAR
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions

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
  • Stale values (Scratched functions) Excel User tips
  • iframe in Excel (XLiFrame) ADDRESS
  • Middle name + 1st name Basic Math
  • Sheet() and Sheets() Lookup and References
  • Schedule column Basic Math
  • Spreadsheet Compare application Excel User tips
  • When Excel tells you to go get some life Excel User tips
  • Scorring, saving multiple outputs in 1 number Basic Math

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme