Hi

I am trying to add values dependant on two seperate criteria

I have tried a formula which I found using excel help but it is adding the
total of the whole column, in other words it is ignoring the criteria.

=SUM(IF((A12:A300="Jones and Co")*(G12:G300="Ordered"),M12:M300))

Column A has customer names, I wanto add the values in column M only when
the customer is a specific name and the status in column G is a specific
status.

I hope this makes sense.

Any help would be appreciated

Thanks