Ok, I *think* this does what you want. Still long, but shorter overall:

=SUMPRODUCT((C13:C23="x")*(ISNUMBER(MATCH(N13:Y23, {"p","m"},0))))*AC1+SUMPRODUCT((D13:D23="x")*(ISNU MBER(MATCH(N13:Y23,{"p","m"},0))))*AC2+SUMPRODUCT( (F13:F23="x")*(ISNUMBER(MATCH(N13:Y23,{"p","m"},0) )))*AC2+COUNTIF(F13:F23,"x")*35

--
Biff
Microsoft Excel MVP


"Centauro" wrote in message
...


"T. Valko" wrote:

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


this is a presence table to determin the amount to pay
basicly the people enter a "X" on this colums C, D and F the value is in
AC1
and AC2 (9 and 19) also if there are a "X" on F13:F23 a prime of 35 is ad,
N14:Y14 are the days of attendance they can be a "P","M" or "F" (p and m =
1,
f = 0)

Tks