+ Reply to Thread
Results 1 to 3 of 3

sumif year

  1. #1
    Forum Contributor
    Join Date
    06-15-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2019
    Posts
    168

    Question sumif year

    Column A has dates including month/day/year. Column B has principal payments on a loan. Column C has interest payments on the same loan.

    Cell D1 is titled “2012 principal”, Cell D3 is titled “2012 interest”. Cell E1 is titled “2013 principal”, Cell E3 is titled “2013” interest”.

    In Cell D2 I wish to sumif if principal numbers in column B are made in the year 2012 from column A. The same sumif for interest in 2012, principal in 2013 and interest in 2013.

    What would the formula be in Cell D2, D4, E2 and E4?

    Regards, Gary

  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: sumif year

    Maybe something like this?

    =SUMIF(YEAR(A:A),2012,B:B))
    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
    Forum Contributor
    Join Date
    06-15-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: sumif year

    Thanks much, this works perfect. Gary

+ 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