Results 1 to 5 of 5

SUMIF - not returning expected result

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479

    SUMIF - not returning expected result

    I have a table similar to below in columns A-D and Rows 1-4, but with many columns (this is simplified), I want the sum of all the data in columns with a column heading of x

    I used this SUMIF formula: =SUMIF(A1:D1,"x",A2:D4) and expected the result to be 16 but got 3

    Have I misunderstood the SUMIF function? What function should I use to get the result I was expecting?

    x y z x
    1 1 1 2
    2 1 3 3
    3 3 4 5
    Last edited by Paul Sheppard; 08-16-2011 at 11:42 AM.
    Paul

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