romovaro

Apr 26, 2024Copper Contributor

# 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...

- Apr 26, 2024
=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.