Forum Discussion
What formula can I use here?
Hello Excel users! I am attempting to setup a formula that will allow me to tally based off of 2 cells. As simplified as I can make the statement, would be as follows: If D2=Yes, determine that t...
This formula is in cell F5 and filled across range F5:I5:
=SUMPRODUCT(($D$2:$D$13="Yes")*(WEEKDAY($A$2:$A$13,1)=COLUMN(A$1)))
This formula is in cell F7 and filled across range F7:H7:
=SUMPRODUCT(($D$2:$D$13="Yes")*(WEEKDAY($A$2:$A$13,1)=COLUMN(E$1)))
This formula is in cell F5 and filled across range F5:I5:
=SUMPRODUCT(($D$2:$D$13="Yes")*(WEEKDAY($A$2:$A$13,1)=COLUMN(A$1)))
This formula is in cell F7 and filled across range F7:H7:
=SUMPRODUCT(($D$2:$D$13="Yes")*(WEEKDAY($A$2:$A$13,1)=COLUMN(E$1)))
- Thank you! This works exactly as intended!
