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
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
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.
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.
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:
Creates the PS*QTY summation for Tipo-A.Formula:Please Login or Register to view this content.
In H3 copied down:
Creates the PS*QTY summation for Tipo-B. - note - the formula cannot simply be dragged across from col-HFormula:Please Login or Register to view this content.
In K3:
Your count for "Tipo-A"Formula:Please Login or Register to view this content.
Your count for "Tipo-B" - note - the formula cannot be simply dragged down from row-3Formula:Please Login or Register to view this content.
Last edited by GeoffW283; 11-06-2020 at 12:23 AM.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks