countifs() what the 5th argument is used for

[lezawang]

Hi
Why countifs() has 5 arguments? what is the 5th one is used for? It works perfect without the 5th one? I just want to find an example when I have to use the 5th one. Thank you so much.

 

[Scott T]

The number of arguments is dependent on how many criteria you have. If you only have one criteria you would use [FONT=&quot]criteria_[/FONT][FONT=&quot]range1, criteria1 only. If you have 3 you would use [/FONT][FONT=&quot]criteria_[/FONT][FONT=&quot]range1, criteria1 though [/FONT][FONT=&quot]criteria_[/FONT][FONT=&quot]range3, criteria3[/FONT]

[COLOR=#2F2F2F][FONT=&quot]COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)[/FONT][/COLOR]

 

[Jonmo1]

Where do you see 5 arguments in countifs ?
By default it has 2 criteria.
Then there are optional arguments that come in pairs, you can't have the 3rd without also the 4th.

 

[lezawang]

Sorry i meant

Countifs(criteria_range1, criteria1, criteria_rang2, criteria2, criteria_rang3)

These are 5 arguments. Why criteria_range3 ?

 

[lezawang]

please ignore my questions. I can enter criteria_range3 and criteria 3 and more criteria_range
I did not use the screw bar to go to see more. i thought it stop at criteria_range3.
Thank you all