+ Reply to Thread
Results 1 to 3 of 3

Array Constant

Hybrid View

zanshin777 Array Constant 08-22-2015, 09:54 AM
Tony Valko Re: Array Constant 08-22-2015, 09:57 AM
Andy Pope Re: Array Constant 08-22-2015, 09:58 AM
  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Array Constant

    There are values (Unit Sold) in A2:A10 range.

    There are values (Unit Price) in B2:B10 range.

    I want to calculate Income. (Unit Sold * Unit Price)

    How should be the formula?

    A2:A10 and B2:B10 ranges are arrays. These are used in formula as array constants here.

    =({A2:A10}*{B2:B10}) It won't work.

    Do I have to write values (From A2 to A10) in array constant one by one? like {1;4;5;7}

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Array Constant

    Maybe this...

    =SUMPRODUCT(A2:A10,B2:B10)

    You may need to use semi-colons instead of commas:

    =SUMPRODUCT(A2:A10;B2:B10)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Array Constant

    Enter as array formula, press CTRL+SHIFT+ENTER

    =SUM(A2:A10*B2:B10)
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using the OR function with an array constant
    By Michael Kuchman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2014, 08:58 PM
  2. Array Constant > Error
    By Paolo Lavazza in forum Excel General
    Replies: 16
    Last Post: 01-27-2014, 12:59 PM
  3. [SOLVED] Sort Array Constant
    By ricklou in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2012, 06:26 PM
  4. Constant Array
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-08-2010, 04:36 AM
  5. Constant Array?
    By Pherion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2009, 05:47 PM
  6. array formula with constant
    By name in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2006, 12:20 PM
  7. A constant array?
    By Thief_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2005, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1