Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with funcions in filtered lists
hello,
i have a list and in column C i have a function that calculates the value from the row above + the value from the row to the left (so C4 reads =C3+B4) when i filter the list the formula is calculating all rows, even the hidden ones. I want it to calculate only the visible ones for the above formula. How do i do that? thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with funcions in filtered lists
Hi, Try this =SUBTOTAL(9,H1:H7) if the row was hidden then this link would help http://support.microsoft.com/default...b;en-us;150363 VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561265 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with funcions in filtered lists
Thank you for your input. To make myself clear I do not want to use SUBTOTAL.
I just want to sum the direct above cell to the direct left one, but in a filtered list (so the visible above cell is what I want to sum, not if it is hidden). Thanks S. "VBA Noob" wrote: Hi, Try this =SUBTOTAL(9,H1:H7) if the row was hidden then this link would help http://support.microsoft.com/default...b;en-us;150363 VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561265 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Lists Where List Size is Unequal | Excel Discussion (Misc queries) | |||
Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
Counting Entries in two lists | Excel Worksheet Functions | |||
Excel - need a function to compare lists | Excel Worksheet Functions | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions |