Please bear with me. This is my first post. I'm sure this is a fairly stupid question, but I'm new-ish to Excel, haven't been able to find the answer in Excel help, and my employer doesn't have any Excel guides. Part of the problem is I don't know WHERE to look in help because I don't know Excel "lingo".
I have two columns, L and M. L is Expenditures for 2001, M is same for 2002. Each row is a building for which the expenditures occurred. I want to create a column N that sums the expenditures for 2001 and 2002 on each building. I know how to do this cell-by-cell using Sum(L1:M1) and so on, but I don't know how to do it all at once.
Again, sorry for asking such a basic question. Without a user's manual, I just don't know where else to turn. Thanks.
I have two columns, L and M. L is Expenditures for 2001, M is same for 2002. Each row is a building for which the expenditures occurred. I want to create a column N that sums the expenditures for 2001 and 2002 on each building. I know how to do this cell-by-cell using Sum(L1:M1) and so on, but I don't know how to do it all at once.
Again, sorry for asking such a basic question. Without a user's manual, I just don't know where else to turn. Thanks.