+ 1 Votes =LEFT Scalloway1 June 28, 2013 at 5:14am PST If "c" is always the first character in the cell you could use this. It assumes that your first item of data is in A1 =IF(LEFT(+A1,1)="c", Then type in what you want to do after the "," + 0 Votes Reponse To Answer gechurch July 6, 2013 at 1:01am PST Grabbing the column headings is simple since you know exactly which cell they are in. Your headings will all be in the first row of Sheet1, so all you need to do is hit "=" then enter the cell containing the heading. For example (assuming the same layout of columns as I posted earlier) to grab the heading "First Name" you'd use the formula "=Sheet1!B1". To grab the surname heading you'd use "=Sheet1!C1" etc. + 1 Votes Full formula Scalloway1 June 28, 2013 at 10:22pm PST If you want to put the formula down every row but only show those with a specific letter then use this for text =IF(+A5="p",C5&" "&D5&" "&E5," ") If you want to add numbers together to get a total =IF(+A5="p",+C5+D5+E5,0) + 1 Votes It depends gechurch Updated - June 30, 2013 at 2:02am PST There are a couple of ways of handling this. One would be to use filtering (highlight your heading row, click the Data tab in the ribbon and click the Filter icon). You can then select the dropdown box on the heading of the column containing your c's and p's and untick the p's. Excel will now only display rows where the first column is a 'c'. You would typically use this in combination with the SUBTOTAL formula for your other columns. For example, if column B contained the total sale amount, using SUBTOTAL at the end of that column will show you the total for only the rows that are displayed (that is, only the rows that start with a 'c'). If you just want to sum a column or two and you do not want to hide rows as you would if you used a filter, then Jojo's suggestion of using SUMIF (or similar formula's like AVERAGEIF) is spot on. Lets say you have two columns; column A contains either 'c' or 'p', and column B contains the sale total. And you have rows 2 through 10 with values. You'd use SUMIF by entering the following formula in cell B11: =SUMIF(A2:A10,"=c",B2:B10) That formula says "look at column A for each row 2 through 10. If the value of column A equals c then include the value of column B in the SUM".