i have a transaction of a few people with the figures. i can only get the
total amount using the filter. so, i want to have a summary in another
worksheet. IS there anyway to do the summary? cos..once i change the
filter in the sheet 1, the total is different.

Please help!.

Thank you.

Pivot Tables, maybe?

A bit hard to tell from your explanation - Excel certainly has plenty of
tools to "do summary"!

"Eliz" wrote:

i have a transaction of a few people with the figures. i can only get the
total amount using the filter. so, i want to have a summary in another
worksheet. IS there anyway to do the summary? cos..once i change the
filter in the sheet 1, the total is different.

Please help!.

Thank you.

Matt,

Thank for helping, to explain more....

i just want to get the subtotal of each candidates in a separate worksheet
showing only the subtotal (summary) for the report purpose. i cant do it due
to the transaction include everyone n the final total is for all the
candidates. i can only get the subtotal of each candidate by using filter.
i need to print out the report, so i need to do a summary. is there any
formula that i can use? i am trying to use "dsum" but, i am still facing
some problem with it. can you help??

Thanks

"Matt Geare" wrote:

Pivot Tables, maybe?

A bit hard to tell from your explanation - Excel certainly has plenty of
tools to "do summary"!

"Eliz" wrote:

i have a transaction of a few people with the figures. i can only get the
total amount using the filter. so, i want to have a summary in another
worksheet. IS there anyway to do the summary? cos..once i change the
filter in the sheet 1, the total is different.

Please help!.

Thank you.