Excel Sumif and Concatenate

[funkylad20]

I have a big spreadsheet with a whole host of data.
It essentially lists a figure (grant award) in different counties of England, with one linear entry per award (ewith other data also)

Some awards are labelled as R, some as C, and some as M.

I need to obtain the sum of all with the label 'R' and the individual county (i.e. the sum of all awards for Bedfordshire labelled as M).

I think it has something to do with sumif and concatenate but am really stuck...

[Old_Geezer]

Not sure I 100% get the problem, but a quick look in the Excel help suggests CountIf might be a better solution since 'C', 'M', and 'R', and not numeric values.

COUNTIF(range,criteria)
i.e. =COUNTIF(A1:A756,"C")

[MarkRae]

The formula you need is SUMPRODUCT()
http://www.google.co....-8&q=Excel+SUMPRODUCT

[dr b]

SUMIF will work even if your criteria are alphabetical.

So if your labels are in column A and the data that need summing are in column B, you'd have:

=SUMIF(A1:A1000,"R",B1:B1000) - make row counter as large as needed, of course

[dr b]

ah, sorry, did not read the question correctly. If you have multiple alphabetical criteria in different columns (A & B) you can create an additional column C where C1 = A1&B1, so C1 would read "MBedforshire" and then you can use column C as your "sum criteria" column.