How can i add the number of cells in excel with given text criteria?
I have a few simple spreadsheets in excel and want to sum a few of the columns in which there is text. E.G. one column is the geographical location. "XYZ" I would like a formula to quickly sum the number of cells that have "XYZ" in it.
I have tried the SUMIF formula but does not seem to be working. i get a blank cell.