Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 12-30-2020, 12:23 AM
Purfleet Purfleet is offline Subtract contiguous values from top cell, continuously in column, till end Windows 10 Subtract contiguous values from top cell, continuously in column, till end Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

I thought we over came the issue with formulas/values?

Anyway the attached has a doubleclick feature to calculate - i dont particually like it as any double click will invoke the macro so you will get error (that can be ironed out)

Currently only working if there is nothing around the numbers to sum, otherwise it picks up all numbers, will try and look later
Attached Files
File Type: xlsm Subtract contiguous values_Purfleet-1_DoubleClick.xlsm (26.2 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtract contiguous values from top cell, continuously in column, till end Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns innkeeper9 Excel 5 08-30-2016 04:43 PM
Subtract value from one cell into another otuatail Excel 3 02-01-2016 03:21 AM
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values bolandk Excel 1 05-15-2014 08:22 AM
Summing Non Contiguous Cells in a Row or Column Joe Ottenhof Excel 4 12-19-2012 04:13 AM
From a particular cell till the end of the same column tinfanide Excel 3 08-10-2011 05:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 AM.


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