Results 1 to 10 of 10

Summing values based on other columns

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Philadelphia
    MS-Off Ver
    Excel 20010
    Posts
    16

    Summing values based on other columns

    Hello,

    I have 3 columns (see attached worksheet): Days, Months, and Numbers. I'm trying to write a formula that gives me the sum of the numbers in the Number column for all cells for which the entry in the first column is Monday and the entry in the second column is January.

    So in my attached sheet, this cell would equal 8 (the sum of C2 & C4).

    Can anyone help me out here? I'd really appreciate it!

    Thanks,

    Jackie
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Summing columns based on matched values
    By Ace_XL in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2013, 11:32 AM
  2. [SOLVED] Summing values in one column based on their adjacent values
    By undoubtedlymegz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2013, 04:57 PM
  3. Summing Highest Values based on two columns
    By seashell in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-09-2012, 07:53 AM
  4. Summing columns based on another column containing unique values.
    By CJPHX in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2010, 02:22 PM
  5. Summing matrix values based on X & Y axis values
    By vtbigmac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2009, 01:29 PM

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