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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
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.
 

majon96

Board Regular
Joined
Sep 25, 2002
Messages
61
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
 

Forum statistics

Threads
1,144,510
Messages
5,724,787
Members
422,579
Latest member
Lekha mohanty

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
Top