Microsoft Office Forums

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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2019, 03:08 PM
Alansidman's Avatar
Alansidman Alansidman is offline Problem> do not include 999 in calculations Windows 10 Problem> do not include 999 in calculations Office 2019
עַם יִשְׂרָאֵל חַי
  
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 121
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default
Use this formula to exclude 999 from the calculation



=AVERAGEIF(B2:J2,"<>999") and copy down.
Reply With Quote
Reply

« 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&gt; do not include 999 in calculations Calculations etobias Word 4 12-03-2015 01:36 PM
Problem&gt; 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:27 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