How do I calculate a column based on two criteria?

[charlesstricklin]

I have been fiddling with this for an hour, mostly using SUMIFS but I'm not getting anywhere. Assume I present the following data:

	A`	B	C
1​	$ 81.00	Expense	Personal
2​	$ 75.00	Expense	Personal
3​	$ 25.00	Expense	Personal
4​	$ 42.00	Expense	Business
5​	$ 14.00	Expense	Personal
6​	$ 59.00	Income	Personal
7​	$ 71.00	Expense	Business
8​	$ 70.00	Expense	Business
9​	$ 91.00	Expense	Personal
10​	$ 88.00	Income	Business
11​	$ 48.00	Income	Business
12​	$ 4.00	Expense	Personal
13​	$ 82.00	Expense	Business
14​	$ 58.00	Expense	Business
15​	$ 49.00	Expense	Personal
16​	$ 71.00	Expense	Personal​
17​	$ 8.00	Expense	Personal
18​	$ 88.00	Income	Personal
19​	$ 3.00	Expense	Personal
20​	$ 78.00	Income	Personal

How do I calculate Business Income, Business Expenses, Personal Profit/Loss, Total Income, etc.?

 

[charlesstricklin]

GROUPBY is not available on all versions of 365. I think it's only available to Insiders at the moment. (Also true for PIVOTBY)

Thanks, I didn't see this until I saw Joe4's response.

 

[Joe4]

Thanks!

You are welcome.
Glad we were able to help.
As you can see, there are various solutions!