Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Functions (Excel 2000)

    Although I'm new at attempting to insert functions into a worksheet, I have one that I think can be done however can't figure it out. I have a spreadsheet in which I'm trying to total numbers in one column however, the function is that it has to add only the numbers which have the matching "terminology" which I'm trying to total. This is in two entirely different columns (C and G) and at least 300 rows. Currently I'm doing it the old fashioned way by creating a formula which compiles this data by my specifying the rows but I think there has to be a better way which will lead to few mistakes.

    Example: Count if (Column C = Jan) then add Column G number to Row 325 Column K. The end result will be the total of all January's in column C for the numbers in Column G.

    Hope this is enough information. HELP!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Functions (Excel 2000)

    How about:

    <pre>=SUMIF(C1:C325,"Jan",G1:G325)
    </pre>


    Adjust the column and row numbers to suit your case.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Functions (Excel 2000)

    Thanks I appreciate that. I works wonderfully. Is there a way to get the first part of the function to stay as is if it's copied. The first cells remain the same and the later ones will be the one that changes when copied.

    Also, can this type of a function be legitimate if done on a different worksheet in the same workbook as the data?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Functions (Excel 2000)

    Like This?
    <pre>=SUMIF($C$1:$C325,"Jan",$G$1:$G325)</pre>

    will "lock on the col and starting row. as it is copied down.

    If referencing other sheets than the function is in, you must include the sheet name.

    Steve

  5. #5
    New Lounger
    Join Date
    May 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Functions (Excel 2000)

    That works. I sincerely appreciate your help. I feel like I've been trying to do this forever and it now works great.
    Doris

Posting Permissions

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