Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Problem> do not include 999 in calculations
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 05-09-2019, 01:27 PM
ArviLaanemets ArviLaanemets is offline Problem> do not include 999 in calculations Windows 8 Problem> do not include 999 in calculations Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
You got me fully confused! Are you writing about same formula, or another one? And what is denominator?

I'm quessing now. When you want in range Q50:C56 to get the number of non-empty cells, then use the formula
Code:
=7-COUNTIFS(Q50:C56,"")
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations etobias Word 2 11-09-2016 10:14 AM
Calculations etobias Word 1 01-08-2016 01:50 PM
Problem> do not include 999 in calculations Calculations etobias Word 4 12-03-2015 01:36 PM
Problem> do not include 999 in calculations Tiered Fee Calculations lynchbro Excel 5 07-17-2014 11:01 AM
How to do Calculations In a Text Box? SteveF Word 4 09-27-2013 08:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 PM.

Contact Us - Privacy Statement - Top

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