Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-20-2010, 06:16 PM
ktpalmer ktpalmer is offline Subtotaling Sequential 0's Windows 98/ME Subtotaling Sequential 0's Office 2007
Novice
Subtotaling Sequential 0's
 
Join Date: Jun 2010
Posts: 1
ktpalmer is on a distinguished road
Unhappy Subtotaling Sequential 0's

Hi everyone!

I need help for a formula to subtotal a set of zeros in the column next to it.
e.g. A1,A2,A3 all = 0, and A4 = 1, then in B3 will be the subtotal 3.
Have attached an example of what I need the spreadsheet to look like.

The formula is going into a spreadsheet that has over 8000 cells in a column, representing every 10 seconds of the day.

Is this possible?



Many thanks, Katie.
Attached Files
File Type: xls example.xls (14.5 KB, 14 views)
Reply With Quote
 



Other Forums: Access Forums

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