Sum up till next empty and to have another cell with non-empty follow the same range

Hi, I am a junior in excel. Please pardon my question.

I have a table where numbers are in row - Row C (Targets) and Row D (Actual Sales).

Row C shows the targeted sales from Jan to Dec (C2:O2)
Row D shows the actual sales YTD

Both rows ends with a total. In row D, it sums up till empty. I have adopted this formula from the forum - {=SUM(D3:INDEX(D3:O3,MATCH(TRUE,(D3:O3=""),0)))} and it works. I did this because I wanted Row C's total to sum up in the same range (i.e. if row D total is till empty, i want row C to sum up to the same range instead of summing up all the target numbers till O2).

How do I then put a formula for row C total to reference to row D's range? Will appreciate the master's help.

Many thanks,
Patrick

Hi,

Welcome to the Forum.

Try the following formula in O2:

=SUM(C2:INDEX(C2:N2,1,COUNTIF(C$3:N$3,"<>"&"")))

drag this down to O3.

See the attached file.

Oh goodness, you're brilliant! Thank you very much, cbatrody!