Validation list summing query

Hi everyone, I hope someone can help me with a summing query.

I have a sales report that has two columns of sales figures recorded per customer. The third column is a validation list showing if the lead is "live" "pending" "Dead" etc.
I'm trying to create a formula that will sum the value of the order, if the third column shows "pending". I have tried variations of "countif/Sumif" options but they all come back as 0:00.

Any ideas?
Thanks very much for any suggestions

Thanks for the quick response. My apologies for my poor explanation. Your suggestion did not quite work as I have two columns that I need summing once the validation list is selected.
As you suggested I have attached the file so you can see what I mean, and have added a (hopefully) better explanation for you.
I appreciate your support

You have your ranges backwards. Try this formula:

Formula:

Please Login or Register  to view this content.

I'm really sorry, but I cant seem to get that formula to work either. The logic seems fine, but the second part of the rule relating to the actual summing function only seems to count one of the columns of data rather than both.
I'm sure it's "user error" so I do apologise for being a poor student.
I have attached the re-worked file with your formula in it so you see what I've done.

I'm sorry, my mistake.

The first argument is the range to evaluate to determine whether to include cells in the sum. It starts evaluating in the upper left corner of that range, and matches each cell to the corresponding cell in the second argument. The shapes don't have to match for it to be a valid formula, but only the cells that correspond will be considered. Therefore you cannot sum two columns of data by providing only one column with criteria.

So we have to do it twice. The correct formula is:

Formula:

Please Login or Register  to view this content.

Happy days !
I played with the previous suggestion and did exactly the same thing, but thought I was bodging it!
Thanks very much for the advice and patience. Job done.

You're very welcome, sorry about that slip. Glad you ended up in the right place! Thanks for the rep, and thanks for marking the thread Solved!