Counting cells in MS Excel 2003

Topic

New Reply

I have a column in a MS Excel spreadsheet, some of whose columns contain numbers and others contain a question mark. Is there a way to count only how many cells contain a number that is great than 0? I don’t wnat the cells containing a question mark to be counted.

Reply | Quote

Replies

I have a column in a MS Excel spreadsheet, some of whose columns contain numbers and others contain a question mark. Is there a way to count only how many cells contain a number that is great than 0? I don’t wnat the cells containing a question mark to be counted.

If your range is A1:C5 use this formula (replace the range accordingly)

=COUNTIF(A1:C5,”>0″)

Reply | Quote