View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] andy.obrien.01@gmail.com is offline
external usenet poster
 
Posts: 1
Default Mutliple Criteria Count function

I am trying to count the number of occurances of two critera happening
but none of the results listed are helping.

example of what I am trying to do:

Region Product Sales
1 A 10
1 B 101
1 C 19
1 D 10
2 A 15
2 B 5
2 C 10
2 D 3
3 A 100
3 B 10
3 C 7

Fine the numer of regions that have sales of greater than 10 sales for
product A

My limited understanding of excel leaves means I cannot solve it.

ANy help gratefully accepted