There's an =countif() function that might work for you.
Debra Dalgleish has a bunch of instructions on counting functions in excel at:
http://www.contextures.com/xlFunctions04.html
And for summing cells at:
http://www.contextures.com/xlFunctions01.html
Marc wrote:
I work at a crime laboratory and produce monthly stats on the types of
evidence analyzed. The master list is about a hundred items. Some are
encountered more than others. Does anyone know a function that will return a
category if the value is greater than one and skip a category if it has a
zero value. This would be the montly report. I've tried using an IF
statement to no avail. Any help would be appreciated. Thanks in advance.
--
Dave Peterson