Complicated question, bad in mathematics!

ljubo_gr

Board Regular
Joined
Dec 6, 2014
Messages
239
Office Version
  1. 2016
Platform
  1. Windows
Hello, THE GREAT MrExcel!
First, i'm bad in mathematics(english too). I need check columns B and E, imports, E column is acctualy on another sheet. In E column there sometimes will be import minus export(to Donald, Obama, Jelzin..), There is the problem, I have to write that import as 60 litres because of that imediate export; so, how to check is quantity of E=B? There will be large amount of data, they might not be in same rows. I need some formula based on those columns Sums.
Any help would be appreciated. Thanks.

https://s10.postimg.org/chlpxsq49/Capture1.jpg


https://1drv.ms/x/s!ArVOOVnFRGX4ha1diMs30cDRGoZ0gA
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

snjpverma

Well-known Member
Joined
Oct 2, 2008
Messages
1,428
Office Version
  1. 365
Platform
  1. Windows
Try this.. You can adjust the range as per your requirement. The below formula will return true if the total of Column B and E are equal.
=Sum(E4:E10)=Sum(B4:B10)
 
Last edited:

ljubo_gr

Board Regular
Joined
Dec 6, 2014
Messages
239
Office Version
  1. 2016
Platform
  1. Windows
Nope! It's not that simple. Maybe my question is impossible. E column has 170 litres, in B col are imports as by paper, 100 Litres. I need somehow, import 300 minus imports(E) 170, minus export 220 minus startQuantity.... ughh I don't know.....
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,191
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
I don't think the formula is impossible I think you are just struggling to explain your requirements.
Guessing here but the below would return true based on your image (there is an extra 100 in column C in your file?).

=SUM(B3:B10)-SUM(E3:E10)-B3=SUM(B3:B10)-SUM(C3:C10)
 

ljubo_gr

Board Regular
Joined
Dec 6, 2014
Messages
239
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

I am struggling.
I have Start quantity of 50 litres. Import is 300 litres, Export can be 300 + 50=350 litres. So i have to compare B & E column, Usually in E column are values from import or import minus export. It's complicated!

If B & E columns are null(zeroes), Export can be up to 50 litres, because 50 Start quantity.
 
Last edited:

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,191
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Ok, to try and understand better with the table below list the 2 comparison figures you are using, literally just the figures i.e.

Comparison 1
+50
+100
+100
+100

Comparison 2
+40
+40
+60
+100
-50

Excel Workbook
ABCDE
2*IMPORTEXPORT*IMPORT's
3START quantity:50***
4*10040*40
5*10040*40
6*10050*60
7**30*100
8**60**
9*****
10*****
11*350220**
12*300**240
Sheet1

 
Last edited:

ljubo_gr

Board Regular
Joined
Dec 6, 2014
Messages
239
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

My question is impossible. Im getting circular reference. :(
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,191
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Your question is not impossible, list the 2 sets of comparison values as I requested.
 

ljubo_gr

Board Regular
Joined
Dec 6, 2014
Messages
239
Office Version
  1. 2016
Platform
  1. Windows
Yes it is. I simply cannot find the way how to sum those ObamaTrumpJelzin litres from C(export) column, and sum them with E column, and check that with B column. :(
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,191
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Can you post the values as requested, I haven't asked you to post or test any formulas, just to post the values that would make the 2 sets to be compared based on the table in post #6 (putting a + or - depending if they are added or subtracted), you must know how you do this manually so you should be able to list the values you use.
 
Last edited:

Forum statistics

Threads
1,140,928
Messages
5,703,220
Members
421,283
Latest member
MacroBegin

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