Hi SHG and davesexcel
Many thanks for your replies, i like both of them,
Thanks
BPJONES
Hi SHG and davesexcel
Many thanks for your replies, i like both of them,
Thanks
BPJONES
Last edited by bpjones; 04-26-2010 at 07:49 PM.
Welcome to the forum.
=SUM(IF(ISNUMBER(M2:M7), M2:M7)) confirmed with Ctrl+Shift+Enter
Entia non sunt multiplicanda sine necessitate
You can also remove vlookup error with this formula
=IF(ISERROR(VLOOKUP(E3,$B$3:$C$11,2,FALSE)),"",VLOOKUP(E3,$B$3:$C$11,2,FALSE))
If an error occurs, it will display a blank
Replace with your own vlookup formula
Hi SHG and davesexcel
Many thanks for your replies, i like both of them,
Thanks
BPJONES
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks