Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 03-04-2013, 04:55 PM
niton niton is offline how to add up quantities in items spreadsheet? Windows 7 64bit how to add up quantities in items spreadsheet? Office 2010 64bit
Competent Performer
 
Join Date: Jul 2012
Posts: 102
niton is on a distinguished road
Default

Like pulling teeth but I think I have it.
Excel quite reasonably assumes the relevant data does not cross a blank row. It would be correct in most cases.
In this case you have to change the equation to include the rows above the blank one.




*******************
Consider rating the thread by going to the "Rate Thread" dropdown.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to add up quantities in items spreadsheet? Spreadsheet Help furface00 Excel 1 12-14-2012 08:30 AM
Outlook 2007 Saved sent items list only holds the last ten items david.peake Outlook 0 06-01-2010 07:27 PM
how to add up quantities in items spreadsheet? Creating a spreadsheet nickypatterson Excel 1 01-14-2010 03:21 PM
how to add up quantities in items spreadsheet? Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM
how to add up quantities in items spreadsheet? Spreadsheet for words Rosie Office 3 06-15-2005 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 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