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, otherwise 0
I custom sorted my file with Customer, Country and Go lIve Date and used the formula below comparing previous row.
=IF(B2<>B3,1,IF(AND(B2=B3,BE2<>BE3),1,IF(AND(B2=B3,D2=D3,BE2=BE3),0,1)))
I have a column called Contract EE (Employees) and I have been asked to filter projects with max 50employees, 100 employees and + 100 employees but I am struggling to add this SUM in my formula. Any help? What I need is the image below showing number of employees for every count of “1” using the formula with the 3 conditions.
Client NameCIDCountryContract EEOps Forecast & ActualsNum of Projects EE SizeCustomer A010002United States209/1/202203 conditions = 1 Project300Customer A010002United States2809/1/20221Customer B010022Sweden405/1/20241 40Customer C010038Egypt604/1/20241 60Customer D010047Singapore337/1/20221 33Customer E010072Spain13/1/20241 1Customer F010109Austria758/1/20221 75Customer G010109Brazil2006/1/202303 conditions = 1 Project358Customer G010109Brazil1506/1/20230Customer G010109Brazil86/1/20231
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, otherwise 0 I custom sorted my file with Customer, Country and Go lIve Date and used the formula below comparing previous row. =IF(B2<>B3,1,IF(AND(B2=B3,BE2<>BE3),1,IF(AND(B2=B3,D2=D3,BE2=BE3),0,1))) I have a column called Contract EE (Employees) and I have been asked to filter projects with max 50employees, 100 employees and + 100 employees but I am struggling to add this SUM in my formula. Any help? What I need is the image below showing number of employees for every count of “1” using the formula with the 3 conditions. Client NameCIDCountryContract EEOps Forecast & ActualsNum of Projects EE SizeCustomer A010002United States209/1/202203 conditions = 1 Project300Customer A010002United States2809/1/20221Customer B010022Sweden405/1/20241 40Customer C010038Egypt604/1/20241 60Customer D010047Singapore337/1/20221 33Customer E010072Spain13/1/20241 1Customer F010109Austria758/1/20221 75Customer G010109Brazil2006/1/202303 conditions = 1 Project358Customer G010109Brazil1506/1/20230Customer G010109Brazil86/1/20231 Read More