Experts,
Is it possible to sum a values in a column with Alphanumeric Character. For Example;
consider these numbers in 1 column
250.10G
50.6G
250G
150.7G
SUM =SHOULD BE 701.4G
Thanks,
Experts,
Is it possible to sum a values in a column with Alphanumeric Character. For Example;
consider these numbers in 1 column
250.10G
50.6G
250G
150.7G
SUM =SHOULD BE 701.4G
Thanks,
Last edited by kingripper; 05-31-2021 at 04:20 AM.
One way:
=SUM(IFERROR(VALUE(SUBSTITUTE(A1:A4,"G","")),""))&"G"
**In versions other than MS365, array formulae are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you very much...
OrFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks