#1
|
|||
|
|||
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
|
||||
|
||||
Perhaps =COUNTIFS(Table1[Group],"=1",Table1[Score],"<=49",Table1[Score],">=0")
__________________
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
|
|||
|
|||
Quote:
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 |