Dynamic SUM

Hello,


Book1.xlsx


Id very much like to ask for some help of solving a sum option of the example chart. In column O id like to have a sum of the values of column G, but a sum only of the lines with same INV values from column I

Id very much appreciate any assistance, thank you in advance.

Try in O2 and copy down:

=SUMIF($I$2:$I$12;I2;$G$2:$G$12)

Good luck!

Thank you very much Estevaoba. It works!

Could i please ask you for one extra functionality option?
Could i have the formula active on if its there is "TRUE" on the same line at column N?

You're welcome. Glad to help.
I don't understand your last request.
Thank you for the feedback and for the reputation added.

How about

Formula:

Please Login or Register  to view this content.