Hi All,
I'm trying to set up so when I input one value it posts another but won't add them up. It doesn't recognize them as numbers. Here's what my formula looks like
=if(A1=A2,A3,"")&if(A1=B1,B3,"")&if(A1=C1,C3,"")
If A1 is a dropdown box with 3 choices and the answers (A3 B3 and C3 )are numbers. When I go to total the numbers it won't recognize them as numbers, so no addition.
Can anyone help me?
yes, add your excel file on the forum, without confidential information.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Is this what you're trying to do?
Formula:
Please Login or Register to view this content.
IT WORKED PERFECT. Thank you so much. I've been struggling for awhile now. I'm an old fart trying to improve myself. Thanks again
George
Glad you got something you can use!
Be sure to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks