How can I set up a template for roommate expenses?

[Gary Brown]

A B C D E
1 Utilities Food Cable Total
2 Joe 5 5 15 =sum(B22)
3 John 5 5 15 =sum(B33)
4 Jim 5 5 15 =sum(B44)
5 Jerry 5 5 15 =sum(B55)

HTH,
Gary Brown

 

[In charge of the bills]

Thank you, Gary! This is very helpful. I appreciate this very much.