Search results

I have solved the problem Number of days with the conditions in the equation in J3 Thank you @pecoflyer and thank you everyone

I'm sorry It seems I made a mistake in explaining what was required. Please accept my apology What is required is: I want to add the conditions in F3-G3-H3 to the equation on I3 I have Excel 16 The file is attached again Thanks

Hi I want to add the conditions in F3-G3-H3-I3 to the equation on J3 I have Excel 16 Thanks

Thanks This is wonderful and what is needed

Sorry,Mo.ilyas I have Excel 16

Hi I used the attached equation, but it does not give what is required Please correct the equation or if there is another way to implement the requirement Thanks

Hi I have a problem with the solver what is the condition I need to add to make the SOLVER select from all the materials The problem is that I have 25 material but the SOLVER selected 4 only, I need the SOLVER to include all the 25 materials in the calculation thanks

hi This is a table of ingredients for animal feed The first table (column H,I,J,K) consists of feeding animals that produce 38 kg of milk per head, and the conversion rate of a kg of feed is 1.4 kg of milk. When the milk yield changes to 36 kilos per head and the conversion rate to 1.38, I...

bosco_yip Thanks that's awesome What if without helper columns?

Thanks for your quick response The file creates a serial with two criteria in column F, the first criteria is Item Code and the second is PO # (I did this manually) I made an attempt with the equations in column J but it failed I would like to make an equation in column F that gives the results...

Hi I want the number with two conditions, ignoring the duplicates as in column F

The first table is made in a lengthy way because I am searching for the item in the reports sheet because it always changes the locations of the items. This takes a long time and makes a lot of mistakes Also, the report sheet contains a lot of data, and what is presented now is just a sample I'm...

Hi I want the results in a table (2) to be the same as the results in a table (1) Please modify the equations in a table (2) or make other equations that give a better solution Thank you

Hi The table in which the rows are required to be converted into columns, to which other tables have been added, in the same form as the attached table with different materials I want to modify the equations to include the vertical table data of the added tables Thanks

Welcome The table in which the lines are required to be converted into columns, to which other tables have been added, in the same form as the attached table with different materials I want to modify the equations to include the vertical table data of the added tables

Sorry There is an error in the previous post and this is corrected : The third is the sum of the first and second. How do I find the number of cows in a year for the sum of the two tables? Thanks

Hi Attached are three tables The first is the sum of the number of cows per day and then dividing them by the number of days of the year to extract the number of cows throughout the year in the first section The second is the same as the first, except that the days of the year are shorter The...

Hi What is the error in the formula in a cell G75? Thanks

This formula is from the work of this forum

Please I want to solve the problem I tried and it didn't work

The references : D5:D16 for high D17:D28 for middle D29:D40 for low D41:D52 for dry1 How do I make it change when I pull the formula from G75 to AP94? Thanks

Hi I want to pull the formula into a cell G75 so that it works on high, middle, low and dry1

Salaries are a general cost and are not allocated to locations Therefore, we are trying to find a criterion for their fair distribution And you solved the best fair standard Thanks vltem

Thanks vltem I will act on your advice It was applied to my work and it gave good results

Hi I have an area of land divided into different locations (as in Table 1), where seasonal crops are grown (as in Table 2). There are also salaries for each location (as in Table 1). I want to distribute these salaries to crops (in Table 2) by two criteria (cultivated area - number of months of...