Report Offensive Message

Syntax

The "="&B1 component creates a conditional reference to the cell that contains the criteria value. The premise is the same as described here: http://www.techrepublic.com/blog/msoffice/how-do-i-reference-cells-in-excel-with-a-countif-condition/4695

Contributr

Posted by ssharkins@...

15th Nov 2011