LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Sum of filtered data

Hi

I have a little problem on how to implement this functionality:

Let's suppose I have 2 coloumns in excel named Value and Name. What I need
to do is to achieve the sum of all the values of a certain name like this:

Value Name
20 Alan
30 John
25 Alan
12 Ana

The result I need is Total Value for Alan = 45


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy just the filtered data? ljCharlie Excel Discussion (Misc queries) 3 February 16th 07 06:38 PM
total on filtered data? martyn Excel Worksheet Functions 3 September 5th 06 02:50 PM
Help to sort out filtered data from the data contained in another sheet of the same workbook No News Excel Worksheet Functions 1 July 28th 06 04:04 PM
Using ONLY the data filtered Fred Zack Excel Discussion (Misc queries) 6 April 14th 06 08:01 PM
Filtered Data into Charts JDB Excel Discussion (Misc queries) 1 February 21st 06 12:33 AM


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"