Forum Discussion

YeasirDekko's avatar
YeasirDekko
Copper Contributor
Jun 27, 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.

Resources