Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two columns in my spreasheet that I'd like to get a count of numbers.
*These columns are in a tab called "Fall 2007-08 (1st term)" The first column (E) has a heading of "BLENDED". If the course is blended, then we select "Yes" from the dropdown list I've created. If it's not blended (a.k.a. online), then we select "No". The second column (F) has a heading of "NEW or REVISED". In in the cells for this column, we can select from another list the values of "New" or "Revised". I also have a tab called "Reports" which contains a lot of calculated data based on this first tab. I would like to create 4 formulas in the "Reports" tab that would show the total number of courses that a - Blended (yes) and New - Blended (yes) and Revised - Not Blended (no) and New - Not Blended (no) and Revised Further, I also have a start date column which contains the official start date of a course. If I could somehow separate out these 4 formulas even further to tell me which are for August, September, October, etc., that would be helpful, too. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter data based on multiple columns | New Users to Excel | |||
formula to count based on data in two different cells/columns | Excel Discussion (Misc queries) | |||
Retreive data from another worksheet based on multiple columns | Excel Discussion (Misc queries) | |||
Retreive data from another worksheet based on multiple columns | New Users to Excel | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions |