Results 1 to 7 of 7

SUMIF - Text & Values

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2009
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    4

    SUMIF - Text & Values

    I've created an example of what I'm working on since it involves personal information. See Attachment...
    ExampleExcel.xlsx

    I need to use 2 criteria to determine the Sum value for A2 thru A5. The Account# and the Type# below row 7 need to be the same as those listed to the right of the Sum column (A2:A5). I can change the Account# and Type# to text, but the Sum Range needs to be numbers.

    I was able to Sum based on the Account range (=SUMIF(Account,B2,Sum), but I still need to make the Type range part of the criteria.

    As you can see in the attachment, A2 = 8 when it should = 2 (as seen in row 8 under Sum Range).
    Last edited by REL; 07-24-2009 at 12:03 PM. Reason: Solved!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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