+ Reply to Thread
Results 1 to 2 of 2

If a cell meets criteria, sum cells on that row

  1. #1
    Registered User
    Join Date
    03-16-2005
    Posts
    3

    Unhappy If a cell meets criteria, sum cells on that row

    Hi. I have several spreadsheets where data is entered for various months. I need to total data for a certain month. I need to be able to say if A1 equals 1 (which represents January) then sum the data in row 1.

    ex.
    A B C
    Month Money Source
    1 1 50 C
    2 10 200 P
    3 3 10 C
    4 1 20 C

    How can I sum just the data from the rows that have Month=1?

    Thank you in advance.

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Greetings:

    You can use the SUMIF function to accomplish this task. As in your example, in your desired output cell enter this formula:

    =SUMIF(A1:A8,"=1",B1:B8) of course, modify the ranges to meet your needs.

    Similarly, if you want to sum for Feb., substitute "=2" for the criteria.

    Good Luck.

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

+ 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