I need to sum up the values above to the first blank cell using a formula with a particular condition. My formula is not working
Code:
=SUMIF($A$2:INDEX($A$2:$A$10;MATCH(TRUE;INDEX($A$2:$A$10=$D$2;0);0));D2;$B2:INDEX($B$2:$B$10;MATCH(TRUE;INDEX($B$2:$B$10="";0);0)))
Can somebody help me with formula (not VBA)