china

Hello guys, I am struggling for hours with this and can't get it right, plase help :( If supplier is from one country, China, I need to sum all amount from column M. If it is not, I need to write that there was no supply outside Europe. =SUMIF(D2:D10,"China",M2:M10) With this function I...

Hi Guys, thanks for reading my post. I've encounter another VBA problem again. The situation is I needa check if the country provided is within my own country list. So I've written below:- Function BSD(Place As String) As String Select Case Place Case "China", "Cyprus", "Czech Republic"...

Good afternoon, I am trying to apply the following formula in B17=IFERROR(INDEX($B$2:$F$11,MATCH($B16,$B$1:$F$1,0),MATCH($A17,$A$2:$A$11,0)),"") but i got error. How to fix the error. Please help me. Data range: A1:F11 DATA; <colgroup><col><col><col><col><col><col></colgroup><tbody> DATE UK...

Hi, I am apply the following index match formula in G3 but I get a error #ref . G3=INDEX($D$3:$G$12,MATCH(J$2,$D$2:$G$2,0),MATCH($I3,$B$3:$B$12,0)) I would appreciate if anyone can give me some guidance. Data range A2:G12 and Desired result range I2:M5 <colgroup><col><col><col><col...

Hi, I am trying to index match with three different table ranges. I am apply the following formula in B16=IF(MATCH(A$15,$A$2:$B$2,0),VLOOKUP($A16,$A$3:$B$12,2,0)) the formula working fine but the problem is every time I have change table ranges. I need one formula for whole table range...

Hello Everyone! I struggled with setting up a formula, that shows the sum of the year to date numbers of the past and current month. In the current month it should be possible to differentiate until which week the sum should be drawn. My guts tell me that a combination of a Index Match...

Hi All, I've series of products data (Product Red, Green...), divided in Region (PACIFIC ASIA)) countries (China, Australia, Bangladesh...) and year (2010-2017). <colgroup><col><col><col span="8"><col></colgroup><tbody> 2010 2011 2012 2013 2014 2015 2016 2017 Grand Total PRODUCT RED 0 0...

Hi all, I have data for countries and I want to group the European ones and to show a subtotal. So my table rows would be something like. Europe UK France Germany Italy US Japan China I easily created a Europe group through right clicking in the field list. However, when I put...

I am struggling to work out an average in a table with two conditions, I have tried averageifs and sumproduct and failed, please help. E.g. I want to know the average of all Cat that are in the UK only, which would be 3.33, or how many Man in China which should average 2. Please help with a...