Problem> do not include 999 in calculations

		Microsoft Office Forums > Microsoft Excel > Excel
Problem> do not include 999 in calculations

FAQ

Thread Tools

Display Modes

05-07-2019, 10:37 PM

ArviLaanemets ArviLaanemets is offline

Problem> do not include 999 in calculations

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 932

Unless I misunderstood you completely, something like this will do

Code:

=((A$30<>999)*(A$30<>"")*A$30+(B$30<>999)*(B$30<>"")*(5-B$30)+(C$30<>999)*(C$30<>"")*C$30+(D$30<>999)*(D$30<>"")*(5-D$30)+(E$30<>999)*(E$30<>"")*E$30+(F$30<>999)*(F$30<>"")*(5-F$30)+(G$30<>999)*(G$30<>"")*G$30)/(COUNTIFS(A$30:G$30,"<>999")-COUNTIFS(A$30:G$30,""))

« 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
Calculations	etobias	Word	4	12-03-2015 01:36 PM
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 11:01 AM.