I need to count how many time a selection come up in my log.

Example:
Tab 1: Log
D E D
1 charge code WR Code Sub. code
2 HR Admin Miscellaneous
3 Facility Admin Miscellaneous
4 Facility Employees New Issue
5 Facility Temp New Issue
6 Facility Temp Miscellaneous

Tab 2: Weekly Report
1 Totals: Formula I used:
2 HR =COUNTIF(Log!D:D,"HR")= 1 good
3 Facility =COUNTIF(Log!D:D,"Facility")= 3
4 Blank (two sections)
5 -Admin =COUNTIF(Log!E:E,"Admin")= 2 good
4 -Miscellaneous =(?) I need only the count that see both
Miscellaneous and Temp to =1 How (If D is Miscellaneous and E is Temp then
the count is 1)

I tryied =countif(D:D,"Miscellaneous",E:E,"Temp") didn't work. Can you help?

--
Susan Kelly