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. |
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. |
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. |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com