Thread: Count function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liz23
 
Posts: n/a
Default Count function

I currently have an array function to sum revenues from a list of customers.
Is it possible to count the number of customer associated with these revenues?

The formula I am using is:

{=SUM(XXX!$BX$5:$CC$13390*(XXX!$CC$5:$CC$13390=0)* (XXX!$CB$5:$CB$13390=0)*(XXX!$CA$5:$CA$13390=0)*(X XX!$BZ$5:$BZ$13390=0)*(XXX!$BY$5:$BY$13390=0)*(XXX !$BX$5:$BX$13390<0))}

Thanks!