Hello everyone. In cell K 22, I'm trying to get the summation from multiplying:
A22 48 UNITS by E22 $36.00
In cell K22, I tried:
=sumA22*E22, but I can't get the value. I know it's because I have UNITS after 48. How do I remedy this?
Thank you for your help.
Remove UNITS from A22 and enter =A22*E22
Entia non sunt multiplicanda sine necessitate
Instead of typing UNITS into your cells, create a custom format using this: 0 "UNITS". If you do this, you only need to type the number into A22, and then it will work as a number.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You could try something like this =--LEFT(A2,2)*B2
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks