This example was recently sent out and shows how to count in a
interesting way. It involves the use of an arrau formula - something
know only in passing, but it doesn't explain how the count reference
the cells it is trying to count over. In the example it needs t
count over the cells b2-b11 and c2-c11 , it checks for two condition
and gives a total of the times either of the conditions is met. It al
makes sense but doesn't work because it doesn't show how you referenc
the cells in the formula.

To count the number of rows that must satisfy criteria from tw
columns:

Insert the following Array Formula (see how to insert an Array Formul
in page 2 of this Tip):
{=SUM((Market="USA")*(Customer_Name="ExcelTip"))}

The result of the calculation is 2. The * symbol in the Array Formul
returns a result equal to the AND operator

--
rs
-----------------------------------------------------------------------
rss's Profile: http://www.excelforum.com/member.php...fo&userid=2452
View this thread: http://www.excelforum.com/showthread.php?threadid=55456