Pop-up message of total amount

Is there any macro that can sum up figures and show a pop-up message of the total amount??

Here is the excel example that i have attached.

sample.zip

Under Account Title (Column C), after it has been filter under user choice (e.g Communications), i want the Total Payment (Column F) to sum up all the amount of the chosen title. And thus show the Total Amount in a pop-up message.

I hope i am clear enough. ??

Regards,
Lily

You could use a PivotTable

http://www.excel-it.com/pivot_tables.htm

i tried the pivot table.

I need to choose the selected item (1 at a time) when using pivot table. And it doesnt show the total sum up amount for me at one go.

I guess my criteria is more than pivot table.

What i actuali want the macro to do is:
1) Able to display all items after user selected (using filter) the category that they want.
2) After display, macro must be able to sum up all the item amount($) and give me the total of it in a pop-up message.
3) If it is unable to display it on a pop-up message, all i would like it to be is at the worksheet itself but on a new column (stating the total amount)

Note: If there were to be 6 records, a sum of all 6 amount($) must calculate in that new column.

Regards,

Lily

Btw,

Thanks to all that have contributed your time solving my excel problem. :D

Regards,
Lily