Joined
·
1,670 Posts
I've got a column that is all Vlookups. On some of the lines, there are #N/A's because it couldn't find the look up... i want these to show as they are. I also want a total at the bottom though of the values that were found, and just using SUM doesn't work because of the NA's. I could manually do A+B+C etc but its a decent sized list.... I looked into the SUMIF formula and im not sure if thatll work... if theres a way to tell it sumif its a numerical value or sumif the cell doesnt = #N/A ? Or maybe there's some other way to do it? I haven't really used sumif before.
Thanks in advance... itll save me a headache and a half.
Thanks in advance... itll save me a headache and a half.