Summing values from a rage containing numerical and textual substring
I have an excel file there quantity I added with date like 09/05/2009=05 and 10/05/2009=05 as on. Each date and quantity added on each column. I want to sum the quantity.
Example 5/12=2, 6/12=30, 7/12=5, 8/12=30, 9/12=30, 16/12=30
I would want to be able to sum a range of cells that contain text like 5/12=2, 6/12=30, 7/12=5, 8/12=30, 9/12=30, and 16/12=30. And in the instant case the value you would want to arrive at with these text strings would be 127 = (2 + 30 + 5 + 30 + 30 + 30).
Is there any way to sum this quantity without date?
I got this formula
but its not working as it is.