Results 1 to 4 of 4

Sum all values that occur in a specified year

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Sum all values that occur in a specified year

    I have 3 tables (titled Fund1, Fund2, Fund3) with columns for cap call and distribution data and the dates. In a summation table below, I'm trying to write formulas for combined calls and distributions per year. The formula for cap calls in 2001 would theoretically read =SUM(Fund1[Cap Calls] in 2001)+SUM(Fund2[Cap Calls] in 2001)+SUM(Fund3[Cap Calls] in 2001). What I'm trying to do is have a formula in say C55 that would maybe incorporate multiple SUMIF formulas that say "sum values in Fundx[Cap Calls] if they fall on a date in the same year as B55." The dates are quarter end, so they're fixed interval. This is for a workbook template, and excess table space will be deleted, so I'm really trying to tie in the "year" cell in the summation table to avoid problems down the road. Thanks.

    Attached includes sample data.
    Attached Files Attached Files

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