How do I count the number of times I get "ERR" in a lookup calc in a column?
D Denise Apr 30, 2008 #1 How do I count the number of times I get "ERR" in a lookup calc in a column?
R ryguy7272 Apr 30, 2008 #2 This should answer your question: http://www.exceltip.com/st/Count_th...l_types_of_Errors_in_Microsoft_Excel/376.html This may be worth a look: http://www.mvps.org/dmcritchie/excel/sumdata.htm This too: http://www.contextures.com/xlFunctions01.html Oh, and this too: http://www.contextures.com/xlFunctions04.html Regards, Ryan---
This should answer your question: http://www.exceltip.com/st/Count_th...l_types_of_Errors_in_Microsoft_Excel/376.html This may be worth a look: http://www.mvps.org/dmcritchie/excel/sumdata.htm This too: http://www.contextures.com/xlFunctions01.html Oh, and this too: http://www.contextures.com/xlFunctions04.html Regards, Ryan---
D Denise Apr 30, 2008 #3 thanks, this is too cool. D ryguy7272 said: This should answer your question: http://www.exceltip.com/st/Count_th...l_types_of_Errors_in_Microsoft_Excel/376.html This may be worth a look: http://www.mvps.org/dmcritchie/excel/sumdata.htm This too: http://www.contextures.com/xlFunctions01.html Oh, and this too: http://www.contextures.com/xlFunctions04.html Regards, Ryan--- Click to expand...
thanks, this is too cool. D ryguy7272 said: This should answer your question: http://www.exceltip.com/st/Count_th...l_types_of_Errors_in_Microsoft_Excel/376.html This may be worth a look: http://www.mvps.org/dmcritchie/excel/sumdata.htm This too: http://www.contextures.com/xlFunctions01.html Oh, and this too: http://www.contextures.com/xlFunctions04.html Regards, Ryan--- Click to expand...
