Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Problem
Hi Can anyone help? I have a basic logging sheet, which is recording reports in and out of my department. Column E shows which sub-team they went to ie Transport, Engineering or Construction. Column G is the date out column. I have a separate table with an overview per team. The overview table lists the teams down the left, and then working across the next column counts the number of reports for each team - easy enough with a basic =COUNTIF(E5:E250,"Engineering") etc...... However in the next column of my overview I want to count those reports completed per team by counting if there is a date in column G, but against the appropriate team. Any ideas? Probably dead simple - but I can't find how to do it! Thanks HDV -- HDV ------------------------------------------------------------------------ HDV's Profile: http://www.excelforum.com/member.php...o&userid=26299 View this thread: http://www.excelforum.com/showthread...hreadid=536989 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count problem | Excel Worksheet Functions | |||
Datedif incorrect month count - February problem?? | Excel Worksheet Functions | |||
Count With Date Problem | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count data entries and date problem | Excel Worksheet Functions |