Results 1 to 12 of 12

SUMIFS Calculation for Cumulative Annual Wages

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-31-2018
    Location
    London, England
    MS-Off Ver
    MS Office 365
    Posts
    104

    SUMIFS Calculation for Cumulative Annual Wages

    Howdy all,

    I have designed a basic Excel spreadsheet to calculate my real wages, based on my monthly salary and the host of different deductions and thresholds the UK government has for me that looks something like this (don't worry, it's all dummy data):
    Table.png

    I am trying to create a column to calculate the cumulative annual wage after deductions, however, my SUMIFS formula is incorrectly constructed and I cannot understand where to go from here. The logic I would like the formula to follow is as follows:

    "For Year = X, then SUM all 'Monthly After Deductions' values in X" where X is the corresponding year of that row, which will dynamically change as more rows are added to the table for each new month.

    In this example, this would make the first and second rows in that column equal to £2,811.78, and the third row onward in that column equal to £8,016.26.

    I would greatly appreciate if anyone could help me structuring a formula that will perform such an action. I have attached this dummy database below for your further understanding.

    Thank you very much in advance for your help.

    EDIT: Solved now. /closed
    Attached Files Attached Files
    Last edited by doubleuson; 06-01-2020 at 02:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 10-29-2017, 06:00 AM
  2. [SOLVED] Find out the time between 1st day to next day for **** wages calculation
    By vrumapathy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-04-2015, 03:22 AM
  3. [SOLVED] Cumulative total sales with annual growth
    By donkeybusiness in forum Excel General
    Replies: 17
    Last Post: 01-07-2015, 10:53 AM
  4. Annual cost calculation based on changes.
    By sekharyadav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2013, 01:30 AM
  5. [SOLVED] Calculation of annual leave
    By youngjeesu in forum Excel General
    Replies: 3
    Last Post: 08-10-2012, 01:08 AM
  6. Annual cumulative interest
    By haloperidal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-28-2012, 11:31 AM
  7. Replies: 0
    Last Post: 08-29-2005, 11:04 AM

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