View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default logic that returns a count

Try this array* formula:

=SUM(IF((B1:B500="Indiana/01")*(D1:D500="enroll"),1,0))

* As this is an array formula, once you have typed it in (or
subsequently edit it) you need to use CTRL-SHIFT-ENTER instead of just
ENTER. If you do this correctly, then Excel will wrap curly braces { }
around the formula - you must not type these yourself.

I have assumed the data is in rows 1 to 500 - adjust to suit.

Hope this helps.

Pete