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!

Count function
 

You can count the number of rows that meet the condition my modifying your
formula:

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

or

=SUMProduct(--(XXX!$CC$5:$CC$13390=0),--(XXX!$CB$5:$CB$13390=0),--(XXX!$CA$5:$CA$13390=0),--(XXX!$BZ$5:$BZ$13390=0),--(XXX!$BY$5:$BY$13390=0),--(XXX!$BX$5:$BX$13390<0))

which doesn't require array entry.


If a row is a unique customer, then this should work. If not, it may be
more complex.
--
Regards,
Tom Ogilvy


"Liz23" wrote:

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!

Count function
 

One way (array-entered):

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


In article ,
Liz23 wrote:

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)*(XXX!$BZ$5:$BZ$13390=0)*(XXX!$ BY$5:$BY$13390=0)*(XXX!$BX$5
:$BX$13390<0))}

Thanks!