Forum Discussion

YeasirDekko's avatar
YeasirDekko
Copper Contributor
Jun 26, 2023

Matching values

Please have a look on the Realized Qty column. I manually calculated realized qty column which is very time consuming because there're more than 1000 rows. When the realized value is blank, I have to sum up invoice qty values until the realized value is not blank. If you closely look at the screenshot, you'll understand my problem. Is there any way I can save my time and work?

 

excel
Formulas and Functions

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jun 27, 2023

    YeasirDekko 

    =IFERROR(SUM(INDEX($A$2:A3,LARGE(IF($C$2:C3<>"",ROW($C$2:C3)),2)):INDEX($A$2:A3,MATCH(C3,$C$2:C3,0))),"")

    You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. Besides cell B2 all values are calculated by the formula. The formula is in cell B3 and filled down.