Forum Discussion
SUM Employees using condition formula
HI I have an issue with one formula. I created a formula to know the number of projects i have within a FY Definition of project: IF SAME CUSTOMER, IF SAME COUNTRY and Same GO Live Date = 1...
=SUMPRODUCT(($A$2:$A$11=A2)*($C$2:$C$11=C2)*($E$2:$E$11=E2)*$D$2:$D$11)
=SUMIFS($D$2:$D$11,$A$2:$A$11,A2,$C$2:$C$11,C2,$E$2:$E$11,E2)
SUMPRODUCT and SUMIFS return the expected result in my sheet. The formula is in cell I2 and filled down.
=SUMPRODUCT(($A$2:$A$11=A2)*($C$2:$C$11=C2)*($E$2:$E$11=E2)*$D$2:$D$11)
=SUMIFS($D$2:$D$11,$A$2:$A$11,A2,$C$2:$C$11,C2,$E$2:$E$11,E2)
SUMPRODUCT and SUMIFS return the expected result in my sheet. The formula is in cell I2 and filled down.
- Thanks Oliver. It works 🙂
