News0 min ago
Excel Sumif and Concatenate
4 Answers
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...
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...
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.