simplify a large formula
Great that make my final formula
=((C13<0)*AC1+(D13<0)*AC2+(F13<0)*AC2)*SUM(COUN TIF(N13:Y13,{"p","m"}))+((C14<0)*AC1+(D14<0)*AC2 +(F14<0)*AC2)*SUM(COUNTIF(N14:Y14,{"p","m"}))+((C 15<0)*AC1+(D15<0)*AC2+(F15<0)*AC2)*SUM(COUNTIF( N15:Y15,{"p","m"}))+((C16<0)*AC1+(D16<0)*AC2+(F1 6<0)*AC2)*SUM(COUNTIF(N16:Y16,{"p","m"}))+((C17< 0)*AC1+(D17<0)*AC2+(F17<0)*AC2)*SUM(COUNTIF(N17: Y17,{"p","m"}))+(SUMPRODUCT(--(F13:F23<0))*35)
i put from row 13 to 17 but in reality willbe from 13 to 23
|