Hello all,
I have been researching this problem across the net and have tried everything from arrays to TRIM with no success.
Here is what I am trying to do (using Excel 2010):
This is just a sample, but I have multiple rows and columns A1:G2, in this example both rows are the range I need.
<tbody>
</tbody>
I have another cell where I will do my calculation. I want to be able to SUM only the numbers in any range I specify ignoring any Text.
I am intermediate when it comes to excel with basic VBA as well but I am open to any assistance I can get
Regards,
Ynygma
I have been researching this problem across the net and have tried everything from arrays to TRIM with no success.
Here is what I am trying to do (using Excel 2010):
This is just a sample, but I have multiple rows and columns A1:G2, in this example both rows are the range I need.
Text | Text | Text | Text | Text 6 | Text 4.5 | Text/Text |
Text | Text |
<tbody>
</tbody>
I have another cell where I will do my calculation. I want to be able to SUM only the numbers in any range I specify ignoring any Text.
I am intermediate when it comes to excel with basic VBA as well but I am open to any assistance I can get
Regards,
Ynygma