Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Sum Countif Function
=IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1), COUNTIF($A$11:$E$12,1),COUNTIF($A$16:$E$17,1),COUN TIF($A$21:$E$22,1),COUNTIF($A$26:$E$27,1),COUNTIF( $A$31:$E$32,1),COUNTIF($A$36:$E$37,1),COUNTIF($A$4 1:$E$42,1)=1),1,"")
I am having trouble with the above formula. It appears to be only looking at the first group of cells (A1:E2) when I am trying to get it to look at all of the listed non adjacent groups of cells and return a 1 if only one number 1 is located. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Sum Countif Function
=IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1), COUNTIF($A$11:$E$12,1),COU
NTIF($A$16:$E$17,1),COUNTIF($A$21:$E$22,1),COUNTIF ($A$26:$E$27,1),COUNTIF($A $31:$E$32,1),COUNTIF($A$36:$E$37,1),COUNTIF($A$41: $E$42,1))=1,1,"") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Cliff" wrote in message ... =IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1), COUNTIF($A$11:$E$12,1),COU NTIF($A$16:$E$17,1),COUNTIF($A$21:$E$22,1),COUNTIF ($A$26:$E$27,1),COUNTIF($A $31:$E$32,1),COUNTIF($A$36:$E$37,1),COUNTIF($A$41: $E$42,1)=1),1,"") I am having trouble with the above formula. It appears to be only looking at the first group of cells (A1:E2) when I am trying to get it to look at all of the listed non adjacent groups of cells and return a 1 if only one number 1 is located. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
COUNTIF and then SUM in Same Function | Excel Worksheet Functions |