Gurus,
I was wondering if I can create a single formula that gets the sum of column of only the values that contain a specific text.
I will have cells that will contain the value "100 *". I want to strip the " *" from that value to get 100. I have created a new column to strip the " *" from the value but I was wondering if there is a way to do that and get the sum in a single formula.
please see my example document. In the yellow cell, I am looking for a formula that will total the two values that contain " *" which would $200.00
TIA,
Tim
Bookmarks