If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summary
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. |
#2
|
|||
|
|||
Summary
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. |
#3
|
|||
|
|||
Summary
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. |
Thread Tools | |
Display Modes | |
|
|