if and

I am trying to do a vlookup (or should I use another function???) of several rows of dates and events, then pull all the events that occur on the same date into a single cell (in a calendar)? For example: Here is the list of events by date 10/29/2008 All-Team Meeting 11/19/2008...

Using XL 2003 Im trying to determine how many Nos are tied to a certain subject. Here is the format: _| Subject | Y/N | 1 SUB1 YES 2 SUB2 YES 3 SUB1 NO 4 SUB1 YES 5 SUB2 NO I have a dropdown on a different sheet where I can select a subject. I want to be able to determine how many nos...