Here's the excel table:
In B16 I'd like to insert the sum of all the cells in the range B1:B10 that have "*" on the right. In this case B16 = 10 + 2 + 7 + 9 = 28
How can I do this with a formula?
P.S. I'm using Excel 2010.
Here's the excel table: In B16 I'd like to insert the sum of all the cells in the range B1:B10 that have "*" on the right. In this case B16 = 10 + 2 + 7 + 9 = 28 How can I do this with a formula? P.S. I'm using Excel 2010. 


You can use
So in your case you would place in b16:
The tilde (~) in front of the 


In column D, put
Then copy this down, and sum row D. 


If you change the * into a 1 (style it with some color), then you can use
In google spreadsheets it would be like this:


