Multiple variables-SOS
I need your expert help in setting this up. I'm building a labor report
that I want to pull data into from another spreadsheet.
Spreadsheet B contains date, department name, hours worked, and dollars by
employee that worked that day. I want to summarize by day in my report:
Department Total Hours Toal $
What's the best, easiest way to do this? Use in intermediate spreadsheet
and set up an array? I've tried sumproduct and for some reason it just
doesn't work...HELP?
THX MUCH!
|