Results 1 to 5 of 5

SUMIFS function?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    163

    SUMIFS function?

    is there a way to sum a column based off of two criteras for the same column.
    so say i have numbers in column A and in column B is my critera the options are UG, GU, P, and GG.
    i want to sum the numbers in column A if the corresponding cells in column B are UG or GU.

    im trying this and its not working
    =SUMIFS(A1:A15,B1:B15,"=UG",B1:B15,"=GU")

    i think that its not working because im referencing the same cells (column B) twice.

    is there another way to make this work? maybe with a OR statement

    any help would be awesome

    thanks
    JED
    Last edited by jed38; 09-06-2012 at 03:42 PM. Reason: typo

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