Range Lookup for Totals? Confused

		Microsoft Office Forums > Microsoft Excel > Excel
Range Lookup for Totals? Confused

FAQ

Thread Tools

Display Modes

02-01-2011, 10:20 AM

lawnG

Windows XP Range Lookup for Totals? Confused

Office 2003

Novice

Join Date: Jan 2011

Posts: 2

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!

Attached Files

help.xls (13.5 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Field Lookup - Confused	lawnG	Word Tables	1	01-31-2011 03:50 PM
Creating Lookup in Excel	vikash kumar	Excel	2	12-06-2010 06:50 AM
Using the LOOKUP Command	Grapejuice	Excel	2	10-15-2008 02:02 PM
Please help with Sum formula to add totals by State! asap	dutch4fire23	Excel	0	07-28-2006 12:41 PM
Need Backup/Export - confused!	Robin12265	Outlook	2	06-04-2006 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:07 AM.