Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Array #value error (2003)

    I need to calculate some data using the array function. Attached is a spreadsheet illustrating what I am trying to do. Basically I need to sum the product of data in one column (AF for e.g) with static numbers in another . This mostly works with the basic {=SUM(AF13:AF498*C13:C498)}. The problem is that the C column sometimes contains N/A values that reference lack of data in another sheet. As a result, the array result is #VALUE. Hopefully I made this clear enough and someone will have an answer. Thanks in advance.

    altin

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Array #value error (2003)

    You could use the SUMPRODUCT function instead of an array formula.

    <code>=SUMPRODUCT(F13:F20,C13:C20)</code>

  3. #3
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Array #value error (2003)

    Works great. Thanks much!

    Altin

Posting Permissions

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