|
|
#1
06-29-2015, 12:49 AM
|
|||
|
|||
IF (to sort a specific criterion?)
Please see the attached Excel file or screenshot of the problem.
testing.png testing.xlsx I want the formula to only count Group 1 entries, excluding Group 2's. Code:
{=IF(Table1[Group]=1,COUNTIFS(Table1[Score],">="&0,Table1[Score],"<="&49))}
' return 4 (should be 2)
The formula did not get rid of Group 2; instead it counted all entries without sticking to the criterion "only Group 1"
I've also attached the Excel file. 
|
|
#2
06-29-2015, 03:11 AM
|
||||
|
||||
|
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
|
|
#3
06-29-2015, 07:37 AM
|
|||
|
|||
|
Quote:
But have I misunderstood the function of "IF"? I just cannot figure out why.
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Linear Mode
