MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Compare value against a list

Posted by Harry on September 26, 2000 5:56 PM

I have to compare a default value against a list of numbers and keep track of how many times the default value appears.

This may be a stupid question but is there any way to compare a value against an entire range of numbers in an 'if' statement????

Posted by Celia on September 26, 2000 6:15 PM

You can use the COUNTIF worksheet function.
Have a look at on-line Help.