IF (to sort a specific criterion?)

		Microsoft Office Forums > Microsoft Excel > Excel
IF (to sort a specific criterion?)

06-29-2015, 07:37 AM

tinfanide

Windows 7 64bit IF (to sort a specific criterion?)

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

Quote:

Originally Posted by Pecoflyer

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.

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
Copy data from spreadsheets to a two, with the sum criterion	marreco	Excel Programming	1	05-15-2012 04:15 PM
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 11:03 PM.