Sumif question

[brfitz329]

I have 2 columns on an expense sheet, 1 for company expenses and 1 for billable expenses then a column with amounts. I want to sum all the values for the company expenses and billable expenses seperately but each item has a different value (ex: parking NYC). How can i do that with sumif or sumifs to just sum for any text value?

 

[Andrew Poulsom]

How would one determine whether the expenditure was company or billable? Some sample data might help.

 

[brfitz329]

They are submited by the employee as either company or billable expenses and then given an explaination as to what the expense was. Ex:

Date Firm Billable amount
1/1/10 Dinner XYZ Restaurant $200
2/2/10 Parking (NYC) $15
3/3/10 Hotel (DC) $275

And so on...I want to be able to sum all expenses in the firm column and all expenses in the billable column seperately

 

[Andrew Poulsom]

For Firm you can use a formula like:

=SUMIF(B2:B4,"<>",$D2:$D4)

copied to the right for Billable.

 

[brfitz329]

Sorry that didnt come through as well as i would have liked...

Col A / Col B/ Col C/ Col D
Date /Firm /Billable /Amount
1/1/10 / (empty cell) /Dinner XYZ Restaurant/ $200
2/2/10 /Parking (NYC) / (empty cell) /$15
3/3/10 /Hotel (DC) / (empty cell) /$275

 

[brfitz329]

Great! thanks it worked perfectly