I use the DSUM formula to count the rows associated with a specific Day/Week/Dept/Person criteria.
I'm using the following DSUM formula with a named range which works just fine with a single criteria:
=DSUM(Table,ActHrs,R.FRED_MON)
The named range is: =ActualHrs!$AN$64:$AQ$65
The cells for the named range are:
Day Week# Department ResourceName
Monday 22 *325* *royf*
What I want to do is be able to search for multiple departments. So I would want 325 OR 326 to be the department criteria. I've tried several different things here but am having no luck. Any help would be greatly appreciated!!
Bookmarks