need an excel formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

gagect

Thread Starter
Joined
Mar 25, 2008
Messages
2
I am running excel 2000 and I need a formula to do what I am fixing to put in if it is possible if it isn't please let me know.
if column c equals the word expense then add column D to Column E and total it below the last row on E if column C equals the word Income then add column D to Column F and total it in the following row of column F
if you can help me with this I would appreciate it ASAP thank you!
 

cwwozniak

Chuck
Moderator
Joined
Nov 28, 2005
Messages
68,875
Will the attached file work for you? It is set to allow up to 30 entries but can easily extended by copying the formulas into additional rows.
 

Attachments

gagect

Thread Starter
Joined
Mar 25, 2008
Messages
2
That works great but is there away this can be done quicker than typing the formula into each row or not. Thinks again it works great it just looks like it is going to take a long time to plug that formula into 21 different spread sheet row by row. If there is another way please let me know.
 

cwwozniak

Chuck
Moderator
Joined
Nov 28, 2005
Messages
68,875
I am using Excel 2003 but this should work for Excel 2000...

Click in the cell in the last row with the formula. You will get a selection box around the cell with a small black box in the lower right hand corner. Place your cursor on the small black box and click on it. Hold the mouse button down and drag down as far as you want. The formula in the first cell will copy to the other cells while adjusting the relative cell references. Repeat procedure for the other column. You should also be able to select two cells at once and drag-copy the formulas in both columns at one time.

Edit: The sheet I uploaded to the site has formulas in rows 2 through 31. You didn't think I typed in 60 formulas did you? :D

Also, in case you didn't notice, the formulas only look to see if the first letter in the contents of the cell in column C is an "I" or an "e" before calculating any value for column E or F in the next row.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top