Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following Dataset
Month Region Amount Jan East 10 Jan East 7 Jan West 5 Feb South 2 Feb South 1 I am trying to write an array function that will count the number of sales in January in the East Region. I have sucessfully been able to write the array function to sum East in January but just found out that the Count function does not accept arrays. Any help would be appreciated. Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inconsistent Array Count results | Excel Worksheet Functions | |||
Count If Array Formula | Excel Worksheet Functions | |||
Count if array contains cells of a certain value | Excel Worksheet Functions | |||
How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
Can I count in an array based on a function? | Excel Worksheet Functions |