Probably a simple summation problem

majon96

Board Regular
Joined
Sep 25, 2002
Messages
61
I have one column that can assume one of two preset values (incoming/outgoing). There's also a column to specify the exact amount of kilos that is incoming/outgoing.

What I want to do is to have one cell containing a formula that makes a summation of (all incoming - all outgoing). How should this formula look, there's about ten rows of information.


Thanks in advance
/Magnus
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
say A1:A10 = "Incoming" or "Outgoing" and B1:B10 = # of kilos

In C1 enter Incoming and C2 enter Outgoing (this is not required for the calculation - but for presentation)

In D1 enter = SUMIF($A$1:$A$10,$C1,$b$1:$b$10)

Copy this formula to D2.
 
Upvote 0
Maybe I wasn't clear enough what I wanted, sorry.

What I want is a summation that calculates all incoming minus all outgoing.

Thanks
/Magnus
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top