View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott Halper Scott Halper is offline
external usenet poster
 
Posts: 32
Default Count & Array Function

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