Range Lookup for Totals? Confused
***question is for excel 2003***
In the attached spreadsheet, i'm having problems getting the total hours and amount based on a certain account number.
I would like to sum the total hours and amount for account number 9 ONLY. And everything other than acct 9, sum as well.
Any help would be greatly appreciated. Thanks!
|