Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-25-2024, 06:28 AM
ArviLaanemets ArviLaanemets is offline Sum values below blank cell Windows 8 Sum values below blank cell Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Instead of copy of paper table from 18.-19. century, use a table with structure like
Name, Amount1, Amount22, Amount222
or even better
Name, WhateverParameter, Amount

Then you can simply create a pivot table which will give you any totals and subtotals you need.
Reply With Quote
 



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
Sum values below blank cell Fill blank cell with value from adjacent cell kevinbradley57 Excel Programming 2 04-17-2018 08:40 AM
Sum values below blank cell Formulato say if cell is blank do this, if not blank do this. mbesspiata Excel 1 01-17-2015 05:02 AM
Sum values below blank cell 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 03:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft