|
|
#1
11-17-2024, 02:17 AM
|
||||
|
||||
Sum values below blank cell
Hi all. I have a spreadsheet that needs a subtotal of values below a blank cell. Is there a single formula that I could use to get the subtotals by filtering the cells where the subtotals are and pressing Ctrl+Enter? I would like to use =SUBTOTAL(109) instead of the SUM function to get the totals.
Attached is a sample table. The real table contains around 3,800 subtotals. Thank you. 
|
|
|
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 |
Windows 11 
Office 2021
Threaded Mode