| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up and Count
I'm using Exel 2007 and need some help creating a formula. Here's what I'm
trying to do. The spreadsheet has two sheets, the first sheet in column C has specific dates and column D has drop down list with a selection of descriptions. Sheet 2 has a week of date in column A (exp 06-02-2008) and the following columns (B, C, D etc) have each of the selections of the drop down list from sheet 1. What I want to do is on sheet 2 in each column next to the week of date find all the dates within that week and count how many times that specific description comes up during that week and display the total under that decription in line with that week of. Any help is appreciated, please feel free to ask if you have any questions, thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
