sum total of specific criteria

**masond3** · 11-11-2011, 04:12 PM

Hi guys

sorry to bother you, but I have been stuck on this particular formula for the last week, and I don’t seem to be progressing any further, and I am hoping you can help

basically there are 2 columns, one with currency the other opportunity type.

what I am trying to achieve with the formula ,

1) if the opp type = close opportunity , I want it to add all the totals within tcv which equals to “close opportunity” and give me a subtotal

hope this is self explanatory , if you have any questions please contact me

**Pauleyb** · 11-11-2011, 06:24 PM

I can't figure out what you are trying to do. I looked at your sheet and it has a column with some currency values, with a mystery number in the next column, and then 'Close Opportunity' a few columns over. There is also a row with 'averages per column' which don't appear to be averages of the columns above. What is 'tcv'? I did not see any range names...

Recommend a clean example with some expected results.

Pauley

**masond3** · 11-12-2011, 05:30 AM

Hey

Please find the correct spreedsheet

there should be two columns, one which is total value contract (which is the currency value) and the other opportunity stage, which will have the following stages "Close Opportunity, n/a, keep trying"

what i am trying to achieve, is if the "opportunity stage column" = close opportunity ,create a formula where it looks at the value of the total contract value
which relates to "close opportunity" and adds up the currency

if i am doing it manually i can see the total for close opportunity is "£76945

hope this makes more sense