If you could explain what you're wanting to do we can probably shorten that
formula as well.

What kind of data is entered in columns C, D and F?

What kind of data is entered in F13:F23 ?

What's in AC1 and AC2 ?

You'd be surprised what we can do when we know the details!

--
Biff
Microsoft Excel MVP


"Centauro" wrote in message
...
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