Simiples ... possibly

[conan]

Hi all,

I was wondering if someone can help me, not sure if this is the right forum?

I have a spreadsheet for each of projects and I have to display actuals each month. In the top corner there is a project number, in the left colum the staff names, and across the rows is the amount spent per month on each member of the teams.


Project number ... D001

Jan Feb Mar
me
You
someone else

I also have a second sheet with staff booking times on

Project number Month Total
me D001 Jan 10
You D002 Jan 20
someone else D001 Feb 50

I would like to know know how to put a formula in the monthly actual spreadsheet that will look at the staff booking sheet and sum the total spend for each individual who is booking to my sheet on a monthly basis?

Is this possible? and if so how?

thanks

C

[Blake 7]

Hi Conan, Your thread title does not conform with forum rules, please check them out........ as an aside i'm not sure that "simiples" is a real word.

It may also help you to be more specific, you mention "Actuals" I don't know what this means and neither does anyone else unless they are looking at your spreadsheet. You also say "in the left column" which left? how far left? left of column Z or R? do you see where this is going? I recomend that you re-title your thread along the lines of Sumif Forumla and include a sample of your spreadsheet demonstrating where you want the formula and WHAT you want it to do.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
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.

[conan]

Thanks for your useless, pedantic response blake7, it is now clear to me I have no desire to use this forum.. RoyUK please could you delete my profile in its entirety! Or at least tell me how I can do this.

I do not wished to be bashed for not knowing which question to ask about when that is the reason I came here in the first place!!! note.

"I was wondering if someone can help me, not sure if this is the right forum? "

[bentleybob]

This IS the right forum. I think the point is to have the problem clearly summarized in the title so people can identify whether or not they know enough to help.

That being said, do you need the information by project number or just in total? The latter should be easy using SUMIF. The other is somewhat more complicated.

It also helps if you attach an example as it helps us all understand your issue and craft a solution that will work for you.

[Richard Buttrey]

Conan,

Clearly you feel aggrieved. However and with respect that does not deserve the sort of reply you gave. Nobody is 'bashing' you, just reminding you about the forum rules.

Before you posted did you take the trouble to read the forum rules? We can only assume you didn't otherwise presumably you would have made sure the subject title was relevant to your problem

Look, we all do this voluntary, your words were unnecessary and the rules are there to help all contributors. The rule about a meaningful title is to assist others who may visit later and want to search the forum for similar requests.

Please remember this.

Regards

[royUK]

I've simply banned you, your response shows that we don't want you as a member, but your reply demonstrates how not to use the Forum