# Day when 50% of total was reached

#### West Man

##### Well-known Member
In A6 through A87 I have days consecutively numbered 1 throufh 82. In B6:B87 I have a count of the responses for each day. I need a formula to give me the day number on which 50% of the total response (sum of daily counts) occurred. It seems like a lookup for = or > half the total response in an array of the "running total" by day, but I just can't get a grasp on it.

Any help will be appreciated.

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
You can add a helper column with formula =SUM(\$B\$6:B6) copied down. This shows your cumulative total.

Then to get day number use: =INDEX(A6:A87,MATCH(SUM(B6:B87)/2,C6:C87)+1) where C6:C87 is the helper column range just added.

=INDEX(A6:A87,MATCH(TRUE,SUBTOTAL(9,OFFSET(B6,0,0,ROW(B6:B87)-ROW(B6)+1))/SUM(B6:B87)>=0.5,0))

which you need to confirm with control+shift+enter, not just with enter.

Thank you both. I will go with Aladin's solution as a helper column is not desired.

Some "formula auditing | evaluate formula" will help me understand the formula.

Again thanks to each of you.

Replies
7
Views
326
Replies
1
Views
2K
Replies
15
Views
1K
Replies
8
Views
987
Replies
3
Views
345

1,219,570
Messages
6,149,046
Members
450,853
Latest member
xtiinctt

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back