Challenges with Countifs function

[mrpwagner]

Using excel 2016.

I am working on a call schedule and trying to make some calculations based on assignment and day of the week - specifically the weekend.

The following formula works great - =COUNTIFS(Vertical!G11:G27,'Names and Values'!J11)
When I run this the formula returns the assignment the patient received.

This formula also works great -
=COUNTIFS(WE_01,"sat")

When I run this formula it returns the number of Saturdays.


HOWEVER, when I combine them I get an error.

=COUNTIFS(Vertical!G11:G27,'Names and Values'!J11,

WE_01,"sat"​

)

Any tips?

Another issue I an having is combining to count the number of Saturdays or Sundays.

=COUNTIFS(WE_01,"sat")​

will give me the correct number of Saturdays; and

=COUNTIFS(WE_01,"sun") will give men the correct number of Sundays. I tried combing in several formats, even using an array. I never get the correct number. Any tips?

Or do I have to do two separate formulas and add them? I would love to learn to combine all these and I would love for anyone in this forum to educate me!!

Thanks a million ahead of time!!​

​

 

[vikas9385]

check the version of all files...all must have same version files...else it gives an error..if you are using one file 65K rows & another higher verson