Search results

Thank you, ma'am; you are amazing

Getting #value Error... after using the same formula which you mentioned.

But there is an issue; suppose some cell entries are with "Kg" and some are other than "Kg" in the selected range; let us say "NA". But we want to sum up only cell entries with "Kg" , means ignore the other than "Kg" cell entries so how can we do it?

Dear Members! I want to add the multiple cells having numbers along with text, but I'm getting #value error. Any member, please dig out the issue and resolve my problem. I am attaching the screenshot. Thanks you.