+ Reply to Thread
Results 1 to 2 of 2

Adding Values from One Column Based on Criteria in another column

  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 365
    Posts
    13

    Adding Values from One Column Based on Criteria in another column

    If i have the following layout of data

    Column 1 Column 2
    January 1000
    January 1234
    February 1300
    March 1600
    January 15
    March 123
    April 234
    January 3000

    I would like a formula that adds all the January numbers together returning a result of 5249

    To move this one step further i would eventually need to add these numbers based on quarters, for example if the value is January February or March in column 1 then add the numbers in column 2.

    I'm sure i have done this before using a countifs maybe but my mind has drawn a blank could someone help

    Many thanks

  2. #2
    Registered User
    Join Date
    11-18-2012
    Location
    London, England
    MS-Off Ver
    Excel 365
    Posts
    13

    Re: Adding Values from One Column Based on Criteria in another column

    I have solved this using SumIFs. Thanks for your time reading this, if someone else needs me to explain happy to do so.

+ 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