# Accounting i guess

1. ## Accounting i guess

I need to make a sheet with a list of active employeesdown column A. If anY text is found in A I need it to multiple that row B through H and put total into I. Is there any easy way to do this so that every time I add or remove an employee it auto figures the formula?

2. ## Re: Accounting i guess

can you uplaod a sheet with sample data to clarify your request

3. ## Re: Accounting i guess

Dont know if it works in 2003 but if you have 4 or more rows of data with the same formula in 1 column, when you fill in another row the formula will copy down automatically as if it was in a Table.

4. ## Re: Accounting i guess

Pens Paper Ink Total
Jon 1 0 0
bob 0 0 1
Steve 4 7 0

In a perfect world i will have the B, C, D cells take the number input times the price of item. Then the total put in E. Not a big problem there. The thing is this is going to be done across multiple departments and 1000 people. I need Excel to know that if any text is in any cell in the A column then it needs to take the numbers from B C D in that row and add them into E. I could go if A1 then, or A2, so on but i need it so people under me can input the name and amount and not have to worry about the formula. I hope this makes sense.

5. ## Re: Accounting i guess

This is a quick mock up of the sheet im looking for

6. ## Re: Accounting i guess

im not quite sure what you mean is this right?

example (1).xls

7. ## Re: Accounting i guess

Thats what I need but I dont want to have to type the formula for every cell in column E. I there a way on the page as a whole IF(A<>"",SUM(B:D),"")

Im sorry im still new at excel i guess it could be something very simple i just need it to know if anything is found in A then that row needs to follow said formula

8. ## Re: Accounting i guess

you just highlight the cell and then click the bottom right corner and drag it as far as you need.

9. ## Re: Accounting i guess

Simple as heck. Dang I feel stupid thank you so much twiggy huge help!!!!!!!

10. ## Re: Accounting i guess

remember if a post helps to hit that lil star button

11. ## Re: Accounting i guess

How does your thread title have anything to do with the question?

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

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

#### 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