Can someone help me solve this problem
I have two formulas that are working correctly that i am trying to add an argument to.
Working Formulas
In cell W2: =COUNTIFS(T:T,"<31")
This formula successfully counts the number of cells in row T that contain numbers less than 31
In Cell X2: =COUNTIFS(T:T,">30",T:T"<61")
This formula successfully counts the number of cells in row T that contain numbers between 31 and 60
So now I am trying to add one additional condition to these existing formulas
Only count if S;S="Pending"
=COUNTIFS(T:T,"<31",S;S="Pending")
=COUNTIFS(T:T,">30",T:T"<61",,S;S="Pending")
I am getting the error of Too Few Arguments on both of the above examples................I am confused, how can I have too few arguments if the only change that I made was adding an additional argument?
Bookmarks