# Thread: Excel Functions (Excel 2000)

1. ## 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. ## Re: Excel Functions (Excel 2000)

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

3. ## 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. ## 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. ## 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
•