Hello everyone , i'm new to the forum and i hope you could me some advice . Also i like to mention that i'm new also to the excel .
I try to make a worksheet that counts some cells with different values . But i need sometimes to add text on the master cell but with the sum function ill get a Value error.. till now i couldn't find a way around . Would nice if some of you could help me out of this situation . The formula is =SUM(K148*5)+(L148*5)+((M148*5)*1.2)+((N148*5)). The only cell that may have not a number but a text in this example is the K148. I hope you understand my problem and i'm sorry about my english since its not my native language .
I try to make a worksheet that counts some cells with different values . But i need sometimes to add text on the master cell but with the sum function ill get a Value error.. till now i couldn't find a way around . Would nice if some of you could help me out of this situation . The formula is =SUM(K148*5)+(L148*5)+((M148*5)*1.2)+((N148*5)). The only cell that may have not a number but a text in this example is the K148. I hope you understand my problem and i'm sorry about my english since its not my native language .