Results 1 to 5 of 5

#VALUE! when summing the products of two column

Threaded View

  1. 06-13-2011, 11:46 PM #1
    arki
    arki is offline
    Registered User
    Join Date
    06-13-2011
    Location
    China
    MS-Off Ver
    Office 2011 MAC
    Posts
    1

    #VALUE! when summing the products of two column

    Hi

    How can I make my formula work when summing the products of two column on the attached table? I am trying to calculate the cost of my product (E78) by summing (C54:C76) with (E54:E76). It returns #VALUE! error.

    I believe it is to do with some text in between the selected area.

    Please help, I don't want to do it like D78 by adding them individually.

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1