Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page IF (to sort a specific criterion?)
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2015, 03:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline IF (to sort a specific criterion?) Windows 7 64bit IF (to sort a specific criterion?) Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Perhaps =COUNTIFS(Table1[Group],"=1",Table1[Score],"<=49",Table1[Score],">=0")
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 06-29-2015, 07:37 AM
tinfanide tinfanide is offline IF (to sort a specific criterion?) Windows 7 64bit IF (to sort a specific criterion?) Office 2010 32bit
Expert
IF (to sort a specific criterion?) 		 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Perhaps =COUNTIFS(Table1[Group],"=1",Table1[Score],"<=49",Table1[Score],">=0")
Yes, absolutely. You're right!
But have I misunderstood the function of "IF"? I just cannot figure out why.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print attachment when it arrive in specific folder with specific subject visha_1984 Outlook 1 01-30-2013 10:42 AM
IF (to sort a specific criterion?) Copy data from spreadsheets to a two, with the sum criterion marreco Excel Programming 1 05-15-2012 04:15 PM
IF (to sort a specific criterion?) Sort problem Cpat Excel 1 09-19-2010 03:08 AM
Finding the difference of two dates based on criterion. aligahk06 Excel 0 04-27-2010 12:12 AM
Analysis of Amount based on following criterion. aligahk06 Excel 1 04-24-2010 10:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 AM.

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