Sum Total Function with Specific Criteria

[shaunguyver]

Tricky one here (at least I think it is) so please bear with with me...

I have a work sheet with three columns - 'ID' (Column A), 'Cost' (Column B), and 'Category' (Column C). The 'ID' just serves as the primary identifier for each entry, the cost is monetary (£), and the category options are 'Black', 'Red', 'Amber' and 'Green.'

I would like a formula in a separate that selects all entries marked with a certain 'Category' (eg. Black) AND a 'Cost' (eg. >£100,000), and totals the 'Cost' values as an output.

For example, if there were 4 entries under 'Black' each at £25,000 each, and 2 under 'Black' at £5,000 each, then a formula asking for all entries under 'Black' and >£20,000 would return '£100,000'.

As ever, any help would be greatly appreciated.

Thank you

[Special-K]

=SUMPRODUCT((C2:C12="Black")*(B2:B12>100000)*(B2:B12))

[AlKey]

Or this

=SUMIFS(B2:B12,B2:B12,">20000",C2:C12,"Black")

[shaunguyver]

Thank you!

What should I do if I want the range to be above a certain value and below a certain value? For example, >100,000, <200,000 ?

[AlKey]

With greater or lower

=SUMIFS(B2:B12,B2:B12,"<20000",B2:B12,">100000",C2:C12,"Black")

[shaunguyver]

That has worked beautifully, thank you both for taking the time to resolve this!