COUNTIFS - To few arguments

[GSAN]

Hi I enter this statement and i keep getting there are too few arguments for this function.

=COUNTIFS(N5,CN5,CG5,BZ5,BS5,BL5,BE5,AX5,AQ5,AJ5,AC5,V5,">=3")

Just wondering if anyone could help me out?

[JBeaucaire]

Countifs is used in parameter pairs. Press F1 in Excel and read the detailed examples in the tutorial.

=COUNTIFS(Range1, Criteria1, Range2, Criteria2, OptRange3, OptCriteria3) (etc...)

[JBeaucaire]

All but one of the cells referenced are 7 cells apart. So all of them can be tested using a SUMPRODUCT, then you can test the remaining cell (N5) specifically:

=SUMPRODUCT(--(MOD(COLUMN(V5:CG5)-15,7)=0), --(V5:CG5>=3)) + --(N5>=3)

That should give you the count you're after.

[daddylonglegs]

COUNTIF needs a range rather than a list of cells

If you are only looking at 12 cells you can use this formula

=(N5>=3)+(CN5>=3)+(CG5>=3)+(BZ5>=3)+(BS5>=3)+(BL5>=3)+(BE5>=3)+(AX5>=3)+(AQ5>=3)+(AJ5>=3)+(AC5>=3)+(V5>=3)

[GSAN]

COUNTIF needs a range rather than a list of cells

If you are only looking at 12 cells you can use this formula

=(N5>=3)+(CN5>=3)+(CG5>=3)+(BZ5>=3)+(BS5>=3)+(BL5>=3)+(BE5>=3)+(AX5>=3)+(AQ5>=3)+(AJ5>=3)+(AC5>=3)+(V5>=3)

thanks for that,

so this sums up how many are greater than 3, but can i count the total numbers above 3??
i.e. if 4 colums are say 5 ea they would = 20 not 4

[GSAN]

All but one of the cells referenced are 7 cells apart. So all of them can be tested using a SUMPRODUCT, then you can test the remaining cell (N5) specifically:

=SUMPRODUCT(--(MOD(COLUMN(V5:CG5)-15,7)=0), --(V5:CG5>=3)) + --(N5>=3)

That should give you the count you're after.

Thanks for this!

how can i get the count of how many are greater than 3 not just count the column that is >3 but to sum the numbers i.e. count 3 + 4 + 3 +6 etc.

[Vikas_Gautam]

Try this..

Please Login or Register  to view this content.

As it is an array formula so use ctrl + shift + enter to enter the formula..

[JBeaucaire]

Thanks for this!

how can i get the count of how many are greater than 3 not just count the column that is >3 but to sum the numbers i.e. count 3 + 4 + 3 +6 etc.

Like so:
=SUMPRODUCT(--(MOD(COLUMN(V5:CG5)-15,7)=0), --(V5:CG5>=3), V5:CG5) + (N5*--(N5>=3))