I have joined just to ask this question as I'm not sure if it's achievable without VBA.
In column A I have a list of values, let's say A1:A9 contain the values "1000" to "9000" respectively.
In B1 I am counting the values like so (with a text addition to cell) ="SDLT "&COUNT(A4,A7)&" units" with the result "SDLT 2 units".
My question is how can I have C3 display the combined values of the cells referenced in B1? (result should be "11000" in this example).
I have played around with INDIRECT and MID to try and find the references but to no avail.
Thanks in advance