Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
I am attempting to count the number of "X" in non adjacent cells, but have
had no success so far. I have recurring table for 12 people being surveyed, so that I am looking to count how many people have certain experience which the X signifies. Using the insert formula I get this: =COUNTIF(C12,I12,O12,U12,AM12,AS12,AY12,BE12,BK12, BQ12,"X") The error is "too many functions" Can anyone assist please, on modifying my formula (or identifying a different formula?) to clear the error? Many thanks, Malcolm |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
I am attempting to count the number of "X" in non adjacent cells, but
have had no success so far. I have recurring table for 12 people being surveyed, so that I am looking to count how many people have certain experience which the X signifies. Using the insert formula I get this: =COUNTIF(C12,I12,O12,U12,AM12,AS12,AY12,BE12,BK12, BQ12,"X") The error is "too many functions" Can anyone assist please, on modifying my formula (or identifying a different formula?) to clear the error? Many thanks, Malcolm Try... =countif(12:12,"X") OR give the cells a defined name and use... =countif(ThisExperience,"X") ...and for another range of cells... =countif(ThatExperience,"X") ...and so on. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF?
Hi Malcom,
Am Fri, 18 Sep 2015 16:13:12 +0100 schrieb Malcolm Austin: =COUNTIF(C12,I12,O12,U12,AM12,AS12,AY12,BE12,BK12, BQ12,"X") if there are only x in these columns you can use the formula from Garry. If there are also x in the other columns the should not be count then try: =SUMPRODUCT(--(MOD(COLUMN(C12:BQ12),6)=3),--(C12:BQ12="x")) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
COUNTIF(--(),--()) help in '97 | Excel Discussion (Misc queries) | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |