In range G13:G17, assume the following entries – VG:25, NS:50, NS:20, #DIV/0! and VG:150. To sum up the values where VG appears, you may refer to my solution in this workbook.
Sum a range of alphanumeric entries ignoring errors
{ 4 Comments }
Hi Ashish,
Thanks for the solution, but I get an error while entering the formula. “The formula you typed contains an error’ and the cursor stays at “NS” in “NS:123”.
-
Hi,
It works fine for me. “NS:123” is in double quotes. Also, please write the formula yourself – do not copy from my reply. Lastly, you have to confirm the formula via Ctrl+Shift+Enter (as against the conventional Enter).Let me know how this works.
-
Thanks a ton Ashish, that worked 🙂
-
You are most welcome. Glad i could help.
-
-
4 Trackbacks