View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_6_] Simon[_6_] is offline
external usenet poster
 
Posts: 3
Default Count occurances based on certain data

Given columns of data, I need to count occurances, based
on certain data.

aa 0123 red 3
ab 0125 red 3
ac 0452 blue 5
ba 0478 white 12
bb 0845 white 1
bc 0654 red 54

I need to only look at data that starts with a "b" (first
column), then I want to count how many colours (3rd
column) have numbers less than "4" (last column).

I suppose that the function should have the colour as an
argument, so when it is called it will return the number
of occurances.

Can anyone help me please.

Simon