+ Reply to Thread
Results 1 to 3 of 3

Sumproduct for year totals

  1. #1
    Registered User
    Join Date
    06-19-2008
    Posts
    63

    Sumproduct for year totals

    What would the formula look like if I wanted to count the amount spent for various charges throughout the year.

    For example:

    ---A------B---
    1 2001 $500
    2 2001 $650
    3 2002 $513
    4 2003 $768
    5 2003 $661
    6 2004 $110
    7 2005 $1056
    8 2005 $809

    So to count for 2003, what would the formula have to be that included looking in the whole range of valuve?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Sumproduct for year totals

    If you want to sum for 2003 then try using SUMIF like this

    =SUMIF(A1:A8,2003,B1:B8)

  3. #3
    Registered User
    Join Date
    06-19-2008
    Posts
    63

    Re: Sumproduct for year totals

    Thank you very much!

+ 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