Sum vertical and horizontal - time tracking by User

[csimo]

Hi

Hope you can help, sorry if this has been covered in another thread.

I have a Spreadsheet with projects running down, with the user that is working on that project. across the top is the Month and the week number. users can be working on different projects in the week.

I need to sum up the users time by week across all projects, and then by project.

Struggling with the sumproduct and sumifs.



Tracker.png



Thanks for any help
Chris

[mikeava]

Hi - can you attach your file? Is easier to work with than just a screenshot.

[csimo]

Hi

Sorry for some reason the attached file isn't working, and ii can't attached a file.

I will keep trying


Thanks

[csimo]

Please see attached file

thanks

[FlameRetired]

Hello csimo. Welcome to the forum.

Are you still using Excel 2003? The *.xlsx file name suggests not. Please update your profile to reflect your current version.

[csimo]

Thank You flameRetired, all updated.

[FlameRetired]

csimo thank you for the update and upload.

In the attached please find in C13 filled down and across this formula.

Please Login or Register  to view this content.

and in C18 this

Please Login or Register  to view this content.

Do these do what you want?

[csimo]

Thank you FlameRetired, think I have been over thinking it and couldn't get to the solution, this is great, is there anyway to also give a summary by Month?
thanks

[FlameRetired]

Yes.

Try this:

	A	B	C	D
21	jan		83	=SUMPRODUCT($C$3:$N$9*($C$1:$N$1=$A22))
22	feb		93
23	mar		80

[csimo]

Thanks FlameRetired all working

[FlameRetired]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.