Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-23-2010, 06:54 AM
Cpat Cpat is offline Subtotaling Sequential 0's Mac OS X Subtotaling Sequential 0's Microsoft Office 2004 for Mac
Novice
 
Join Date: Jun 2010
Posts: 4
Cpat is on a distinguished road
Default Solved with 2 columns

I have a 2 column solution, the left column builds a running total and the right containing the sums of all the 0's.

The left column contains:
=IF(P6=0,IF(Q5>0,Q5+1,1),0)
for all rows.
the right column contains:
=IF(Q6>0,IF(Q7=0,Q6,""),"")
for all rows.
Then to get a total count in all the rows, sum the right column.
Give this a try
Reply With Quote
 



Other Forums: Access Forums

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