+ Reply to Thread
Results 1 to 3 of 3

Stuck on a SUMIF function

Hybrid View

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2000
    Posts
    2

    Stuck on a SUMIF function

    Hello!

    I am racking my head trying to figure out this formula. I'm trying to do a home expense report and can't figure out how I can get a total of how much I spent on a certain category. For example, I want to sum up the amount I spent in Auto & Transport in a seperate column so I can index it each month.

    Column A Column B
    1 $23 Auto & Transport
    2 $10 Groceries
    3 $12 Groceries
    4 $14 Auto & Transport

    I have a seperate column C with Total of Auto & Transport and I want the formula to say something like:

    If Column B1:B4 = "Auto & Transport", then sum "Column A1:A4". The amount would be in a seperate column ie: column D1 and it would equal $37 ($23+14).

    Please help!

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Stuck on a SUMIF function

    Try

    =SUMIF(B1:B4,"Auto & Transport",A1:A4)
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2000
    Posts
    2

    Re: Stuck on a SUMIF function

    Grrrrrrrrrrrreat! Thank you! so easy!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1