Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count function not working, keeps displaying 0 | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Count If Function | Excel Worksheet Functions | |||
count if function with if statements | Excel Worksheet Functions |