Try

=SUMPRODUCT(--(M33:M1000="LJA14"),--(W33:W1000="AP01"),V33:V1000)

If this post helps click Yes
---------------
Jacob Skaria


"SonjaLouise" wrote:

I have a spreadsheet that contains three colums , one that contains text such
as "AP01, AP02, AP03), the second containing text such as "LJA014, NHA003",
and the third containing the associated costs. I am trying to create a
formula that will add the costs of the third column to give me one overall
cost, only if the conditions in both the text columns agree. I have tried the
following -

=IF((M33:M1000)="LJA14",IF((W33:W1000)="AP01",SUM( V33:V1000),0),0)

but this gives me a #value error.

Is what I am trying to do possible, and if so how can I amend this to make
it work.