Sum based on condition

[jayjaysb]

Hi Evry1, Hope you clever peeps can help.

I want to total column C, but only where column B contains certain data, like add column C where column b contains abd so that i get the answer 7, Hope ive explained it right, the formula would be much appreciated.
Thanks Jay

B C
abd 1
abd 2
bmr 3
abd 4
crc 2
crc 3
bmr 2

[protonLeah]

From Help:
SUMIF

Adds the cells specified by a given criteria.

Syntax

SUMIF(range,criteria,sum_range)

Range: the range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.

Criteria: the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, "32", ">32", or "apples".

Please Login or Register  to view this content.

[jayjaysb]

Thanks for that Protonleah, Soooooooooo easy when you know how, Much obliged to you, Merry Crimbo and Happy New Year. Jay