Well, since I don't know what the possible entries can be here's a generic
approach:

=SUMPRODUCT(--(F13:F23<0))*35

--
Biff
Microsoft Excel MVP


"Centauro" wrote in message
...


"T. Valko" wrote:

Try this:

=((C13<0)*AC1+(D13<0)*AC2+(F13<0)*AC2)*SUM(COUN TIF(N13:Y13,{"p","m"}))

--
Biff
Microsoft Excel MVP

greate works!! now this one

=IF(F13=0,0,35)+IF(F14=0,0,35)+IF(F15=0,0,35)+IF(F 16=0,0,35)+IF(F17=0,0,35)+IF(F18=0,0,35)+IF(F19=0, 0,35)+IF(F20=0,0,35)+IF(F21=0,0,35)+IF(F22=0,0,35) +IF(F23=0,0,35)