LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default Count of Data Based on Multiple Columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter data based on multiple columns [email protected] New Users to Excel 4 April 28th 06 04:43 PM
formula to count based on data in two different cells/columns Cachod1 Excel Discussion (Misc queries) 3 January 30th 06 10:18 PM
Retreive data from another worksheet based on multiple columns hgopp99 Excel Discussion (Misc queries) 6 January 22nd 06 02:27 PM
Retreive data from another worksheet based on multiple columns hgopp99 New Users to Excel 1 January 20th 06 08:48 PM
count number of cells based on TWO conditions (2 different columns Troi-Xanh Excel Worksheet Functions 2 February 12th 05 12:46 AM


All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"