Results 1 to 13 of 13

sumproduct problem when combine with if statement

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2012
    Location
    langkawi
    MS-Off Ver
    2007
    Posts
    46

    sumproduct problem when combine with if statement

    I currenty use sumproduct function

    i got 3 column which contain data

    in my sumproduct, i need to know the total of specific item on spesific condition

    example

    if i select item in column 1 plus specific item in column 2, it will calculate the total of the condition i select

    my problem is, i want to select column 1 but dont want to select column 2 that will give the result of the sumproduct of column 1
    but it give me error (#value)

    attach is my example

    thanks
    abu
    Attached Files Attached Files
    Last edited by alimamak; 06-27-2012 at 02:21 AM.

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