Results 1 to 8 of 8

Thread: Summing Data based on certain criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14

    Summing Data based on certain criteria

    I would like to add the data highlighted in Col A, which I have named "other_Income". The values applicable to these items are in Columns F, I & J

    I have used the sum function to show you what the answer should be. Could one use a range name and then an offset function to add the values based on the criteria or use sumifs?

    It would be appreciated if you could assist me with a formula to add a series of data based on crieria such as this.
    Attached Files Attached Files
    Last edited by Rick Rothstein; 01-28-2013 at 09:59 PM.

Similar Threads

  1. Replies: 4
    Last Post: 05-05-2013, 04:01 AM
  2. Split data based on criteria
    By Mahesh.sreekakulam in forum Excel Help
    Replies: 3
    Last Post: 06-08-2012, 09:30 PM
  3. Replies: 7
    Last Post: 03-06-2012, 07:49 AM
  4. Lookup Based on Criteria
    By maruthi in forum Excel Help
    Replies: 2
    Last Post: 02-15-2012, 08:49 AM
  5. Find Value Based On Criteria
    By excel_learner in forum Excel Help
    Replies: 10
    Last Post: 07-30-2011, 10:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •