Excel: Help... Count Values excluding SUBTOTAL

Dear friends... I have product range wise random values in column D, and there are subtotals for each ranges in the same column I need to count the cells where numbers are not equal to zero, but i want to exclude subtotal cells.. how this is possible?

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of May 28, 2014.

For more resources for Microsoft Excel