Sum values below blank cell

		Microsoft Office Forums > Microsoft Excel > Excel
Sum values below blank cell

FAQ

Thread Tools

Display Modes

11-24-2024, 07:05 PM

Marcia

Windows 11 Sum values below blank cell

Office 2021

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

Quote:

Originally Posted by Pecoflyer

I don't quite understand your query

Okay. In the attached sample table, if I select C8:C35, what is the formula that would get the subtotal of all values above the formula until the blank cells? That after entering the formula, I press Ctrl+Enter to apply the code in all the selected cells where the subtotals should be?
Thank you.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to match values in one column to values in six others and return the value of a cell from corre	SnakeDoctor	Excel	4	09-09-2024 12:55 PM
IF cell in Col A is populated BUT cell in Col C is blank DELETE ROW	ChrisOK	Excel Programming	7	05-05-2019 09:00 PM
Fill blank cell with value from adjacent cell	kevinbradley57	Excel Programming	2	04-17-2018 08:40 AM
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
Convert non-cell input to cell values	TBD	Excel	3	06-09-2014 06:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:58 AM.