Sum and count until a determined value

[HFGurgel13]

Hi Guys,

Does anyone know how to help me with this situation:

I need to sum a column until the sum based on two conditions.
At file attached I need sum the column C if column B is equal "Tipo A" and until reach the sum 8000 at column E.


Thanks

[hrlngrv]

More details needed.

There are 5 records in B2:E11 for Tipo A. The last one in row 11 exceeds 8,000 all on its own, and the other 4 combined total 5,268.04 (rounded). No way to reach 8,000.

[HFGurgel13]

Yes, I know that...

Let me try to explain better, Tipo A doesn't reach 8000 until row 11 ok? So the formula will sum column C until row 11, the result is 8.

[GeoffW283]

This attempt gets the expected answer for your example, but I'm not sure that the solution is going to be readily extensible to your real needs.

HFGurgel13.png

I need one helper column per distinct value in the TP column, so for your example I need one helper for "Tipo A" and a second helper for "Tipo B"

In G3 ("Tipo-A" helper) copied down:

Please Login or Register  to view this content.

Creates the PS*QTY summation for Tipo-A.

In H3 copied down:

Please Login or Register  to view this content.

Creates the PS*QTY summation for Tipo-B. - note - the formula cannot simply be dragged across from col-H

In K3:

Please Login or Register  to view this content.

Your count for "Tipo-A"

Please Login or Register  to view this content.

Your count for "Tipo-B" - note - the formula cannot be simply dragged down from row-3

[HFGurgel13]

Thanks a lot!