| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hidden rows problem
hi,
i dont knw is it possible or not and have small idea about excel.my worksheet rows is filtered..and there is some hide rows.and i want to sum only those filtered data that is visible. as like- rows date particulars Dr Cr total actual shown should be 1 02.08.10 paid by cash 4500 4500 4500 4 02.08.10 paid by cash 8000 12500 wrong ans 8 03.08.10 paid by cash 4000 16500 wrong ans 10 04.08.10 paid by cash 6000 22500 wrong ans but in total column it calculate unhide rows when i dragging and give wrong ans.is there is any formula that i can calculate dis visible rows only..thnx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with hidden rows automatically unhiding | Excel Discussion (Misc queries) | |||
| Problem using group function with hidden rows | Excel Programming | |||
| very odd problem - rows have disappeared. Not hidden, height is no | Excel Discussion (Misc queries) | |||
| Problem printing hidden rows | Excel Programming | |||
| Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
Threaded Mode
