<div>
Hi,<br />
<br />
I use it to count non-zero values, for example:<br />
=COUNT(1/B1:B15) - confirm with Ctrl+Shift+Enter will give you the number of non-zero values (numbers) in the range, because 1/0=#DIV error.<br />
<br />
(Yes, I know it could be done in different way, without array-entered formula. :-)<br />
<br />
Cheers,<br />
Kris
</div>


Hi,

I use it to count non-zero values, for example:
=COUNT(1/B1:B15) - confirm with Ctrl+Shift+Enter will give you the number of non-zero values (numbers) in the range, because 1/0=#DIV error.

(Yes, I know it could be done in different way, without array-entered formula. :-)

Cheers,
Kris

<div>
Dave , superb answer: &nbsp;clear, well organized, concise but comprehensive, and enjoyable to read. &nbsp;Many thanks!
</div>


Dave , superb answer:  clear, well organized, concise but comprehensive, and enjoyable to read.  Many thanks!

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
It seems that not infrequently, I see &quot;inverse &nbsp;arguments&quot; used in Excel formulas. &nbsp;By inverse, I mean 1/B1:B15 rather than simply B1:B15. &nbsp;Can someone explain the basic concepts underlying those types of arguments or point me to a source which does?<br />
<br />
Thanks
</div>
</div>


Hello,

It seems that not infrequently, I see "inverse  arguments" used in Excel formulas.  By inverse, I mean 1/B1:B15 rather than simply B1:B15.  Can someone explain the basic concepts underlying those types of arguments or point me to a source which does?

Thanks

Using &quot;inverse arguments&quot; in Excel formulas

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Using &quot;inverse arguments&quot; in Excel formulas

Using "inverse arguments" in Excel formulas