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
If you change the * into a 1 (style it with some color), then you can use
In google spreadsheets it would be like this: