Results 1 to 11 of 11

Need some array help

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2011
    Location
    New Jersey
    MS-Off Ver
    Excel 2003
    Posts
    9

    Need some array help

    So I have Array A and Array B; I have to multiply them together (Array C), sum Array C, and then divide Array C by the sum of Array B

    Example:

    A - B
    0.5 - 150
    0.4 - 200
    0.2 - 400

    So what I usually do is: sum((A2:A4)*(B2:B4))/sum(B2:B4) ctrl+shift+enter, but I want to create a function that does this for me where I could just enter the range A2:B4 as the input argument

    Any help? I have been trying but Excel is being a pain with the summing of Array B
    Last edited by akeiser88; 08-24-2011 at 02:07 PM.

Thread Information

Users Browsing this Thread

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

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