How to automatically sum in excel for filtered data

		Microsoft Office Forums > Microsoft Excel > Excel
How to automatically sum in excel for filtered data

08-05-2013, 12:53 AM

msi_g

Windows 7 32bit How to automatically sum in excel for filtered data

Office 2010 32bit

Novice

Join Date: Aug 2013

Posts: 1

How to automatically sum in excel for filtered data

I want to sum the total amount of hours worked for a project chosen from drop-down menu.

My screenshot is as below

Total Worked Hours for Project No 4 will be the total hours worked for project no 4

Thanks in advance

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Push data automatically from Acess or Excel to create a Gantt chart in Project	GST2212	Project	3	07-06-2012 12:52 PM
How do I know when mail is filtered	Andoheb	Outlook	2	01-09-2012 04:43 PM
How to create an Excel add in that will automatically build tables from data	selvamariappan	Excel Programming	1	12-12-2011 03:11 AM
How to copy automatically data from Excel file to Word file?	fuchsd	Word	6	10-25-2011 05:52 AM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.