|
|
#1
11-23-2016, 02:59 PM
|
|||
|
|||
Subtracting two cells if there are values in them
i have been working on an excel sheet where i am collecting data from a house (how much electricity it uses)
I do not get a number every day, some some cells dont have number in them. How can i make excel subtract the lower value from the top value. There is a value in C4, but not in C5. So i want excel to subtract cell C6-C4? Is there a way to make excel do this automactically?  Thank Josh 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Shortcut to haven ascending values in row/column of cells
|
Straitsfan | Excel | 1 | 08-09-2016 05:28 AM |
|
Excel cells changing values
|
theexpat | Excel Programming | 5 | 02-27-2016 10:36 PM |
| Slow response updating cell values & calculated cells XL2013 | kdash | Excel | 1 | 05-06-2015 10:05 AM |
|
Merging cells and keeping all the data/values
|
Holgate1967 | Excel | 1 | 11-29-2013 09:37 AM |
| Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
Windows 10 
Office 2016
Threaded Mode