1

Topic: To learn the data from cells (date) when reach the intermediate total on set .

The people, help, please, I fight the third day. I understand as should be logically solved, but a functional of formulas Excel it is impossible to solve.
It is given: many suppliers at everyone unique , they pay on different Channels (only 3 channels = 3 columns), kol-in payments (lines) beyond all bounds, are all registers manually in one general table, with  in an appropriate column of date of payment.
It is necessary: to learn when the certain total (in an example it is entered manually) on set ID (also in an example is hammered manually) is reached. The intermediate total (which it is compared to the gated in total) should be formed from lines and columns simultaneously, corresponding set  (i.e. the total of all elements (payments) two-dimensional array, on set ).
File I apply.

2

Re: To learn the data from cells (date) when reach the intermediate total on set .

The file that that was not attached.

3

Re: To learn the data from cells (date) when reach the intermediate total on set .

Cy4eHoK wrote:

here there should be a formula producing date when the total from a cell above is reached (in the given example the answer should be 18,88 USD )

Date in dollars it is strong...

4

Re: To learn the data from cells (date) when reach the intermediate total on set .

Akina wrote:

it is passed...
Date in dollars it is strong...

Litter))) I Speak, 3 day I fight (already even 4). Certainly, the answer should be 5.12.16 since the total more than the entered is reached.
I attach a file with the correct comments.

5

Re: To learn the data from cells (date) when reach the intermediate total on set .

I here added to you of heels of columns... Further itself, and?

6

Re: To learn the data from cells (date) when reach the intermediate total on set .

Cy4eHoK;
One auxiliary column with the formula

 = ((B$2:B2 = $ C$25) * $D$2:F2)> = $C$26 

In target cell the formula

 = (C:C;  (TRUE; G:G;)) 

7

Re: To learn the data from cells (date) when reach the intermediate total on set .

Akina, Kazan;
Many thanks to you for diligence!
In a variant Kazanisky to launch a cycle and the intermediate column it would be not necessary, I so understand, but I will not understand yet as sad
Here, by the way, found a similar problem - http://www.sql.ru/forum/943751/excel-ci … hhu-formul
There just launched a cycle (cells in a column I, in a file 3.xls), I try to make similar, deduced the formula:

{= (C$2:C$12; THE LEAST (IF ((B$2:B$12=C25) * ( ((B$2:B12 = $ C$25) * $D$2: $ F$12)> = $C$26); THE LINE ($2: $12)); THE LINE ()))}

But it not the worker though on my logic should work. And still that is not clear - why depending on a line in which the given formula is (copying it, without stretching) it produces different result (that at me that in that example on which gave the reference). Who can explains and helps  the given formula?