Hello Excel gurus- I have a quick question that I'm sure can be answered in a matter of seconds.
I have an excel spreadsheet setup with the following colums:
Columns:
A: Assignment Date
B: Company Name
C: Fee
D: Expenses
E: Info
In the bottom row I've created two cells where I've created a function to give me the sum of fees and a sum of the expenses.
My question is I'd like to create a cell function in the bottom of the spreadsheet that gives me totals by individual companies. To do that I would need some sort of sumif function, but can't figure it out.
So for instance if I have 100 entries in the spreadsheet and every 5 entries is from company: "XYZ", how would I create a function to then add only the shopper expenses from column D in the same row as Company XYZ while avoiding the expenses from all the other companies?
I hope that makes sense.
FYI- i'm still working and actively modifying this spreadsheet so I want something that will adapt when I make changes.
Also i'm using Office Excel 2003 SP 1
Thank you!
Jason
I have an excel spreadsheet setup with the following colums:
Columns:
A: Assignment Date
B: Company Name
C: Fee
D: Expenses
E: Info
In the bottom row I've created two cells where I've created a function to give me the sum of fees and a sum of the expenses.
My question is I'd like to create a cell function in the bottom of the spreadsheet that gives me totals by individual companies. To do that I would need some sort of sumif function, but can't figure it out.
So for instance if I have 100 entries in the spreadsheet and every 5 entries is from company: "XYZ", how would I create a function to then add only the shopper expenses from column D in the same row as Company XYZ while avoiding the expenses from all the other companies?
I hope that makes sense.
FYI- i'm still working and actively modifying this spreadsheet so I want something that will adapt when I make changes.
Also i'm using Office Excel 2003 SP 1
Thank you!
Jason