Are you stuck on Excel or Google Sheets?

I need a formula that sums values across a range of dates. for example: Let's say I have Jan - Dec in a row, with corresponding values below. Once I select Jun, the formula should sum up all values from Jan-Jun!

i want to sum the unique data from a list then return the sums as subtotals and then sum the subtotals as a grand total

how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22 Our goal is to be able to show the percentile rank of the 10 companies for their mean.

I need a formula which can sum up several cells and tell me its percentage from a total in another cell

Hello I am trying to use Auto sum . After I total up some cells, When I go to change one cell it does not total up automatically. I have to reuse auto sum every time I make a change. Do you know how I can fix that?

i need a formula to return and sum unique items from a list

The sum of NUMBERS, not text, add up to zero instead of the correct number.

auto sum is not showing correct number, it doesn't with dragging across numbers either.

I need a formula for the sum of row a1-a500 where its a1*a2 + a3*4 + a5 * a6... etc

I need a formula that takes the sum of one cell and times every 10 by 43 and the last 5 by 22.50