Sumifs with weekdays + another cell

[Rana Gray]

Hello Lovelies!

I have a formula that counts how many times a weekday occurs within a set range (Trial1 (B8:B107)), now I am trying to add an additional condition.

I want to count the weekday but only if the correlating cell in "column E" is not blank ("<>"). See below for visuals

Thanks a Bunch in Advance!!!!

Current Formula: =SUMPRODUCT(--(WEEKDAY(Trial1,2)=S6)) **Adjusted for each weekday **

 

[Rana Gray]

EDIT TO ADD: I have tired adding an additional array to the "SUMPRODUCT" function but it won't seem to work:

=SUMPRODUCT(--(WEEKDAY(Trial1,2)=S6))*(--(CCAPS_Account1="<>")) **CCAPS_Account1 = E8:E107**

 

[Rana Gray]

Nevermind I figured it out - Thank you all

 

[Joe4]

Please don't mark a post as the solution unless you post the actual solution.
If you do post your actual solution, then you can mark that as the solution.