if and

I am recording my work schedule in a money spreadsheet, I have all of the data for shift date, time, hours, pay, money, etc. Then in a new chart I am representing Weekly Values such as number of shift, hours, and money. I have the weeknum function as a pivot and then I was able to manipulate the...

Does anyone have some resources or links to good information pertaining to IF AND STATEMENTS and what a typical argument entails, thank you!

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...