Summary
in [Functions]
|
Prev: Group information from several worksheets into one worksheet
Next: Import multiple photos into excel
From: Eliz on 8 Mar 2010 22:29 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.
From: Matt Geare on 8 Mar 2010 23:38 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. > >
From: Eliz on 9 Mar 2010 22:04
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. > > > > |