| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS including hidden rows
Hello,
I am using the SUMIFS function but I have alot of rows hidden because otherwise it will become a very long list of data and I only need to see the latest added numbers but I do need to see the total sum of the SUMIFS function but I seems it will only give me the unhidden cels. Can anybody tell me how to include the hidden cels ? Thanks in advance Jeroen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIFS including hidden rows
SUMIF DOES include hidden rows, manually hidden and/or hidden by a filter,
so I cannot see your problem here. -- __________________________________ HTH Bob "moosie" wrote in message ... Hello, I am using the SUMIFS function but I have alot of rows hidden because otherwise it will become a very long list of data and I only need to see the latest added numbers but I do need to see the total sum of the SUMIFS function but I seems it will only give me the unhidden cels. Can anybody tell me how to include the hidden cels ? Thanks in advance Jeroen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a range in Excel without including hidden rows? | Excel Discussion (Misc queries) | |||
| How do I add up column of numbers without including hidden rows? | Excel Discussion (Misc queries) | |||
| How do I get excel to sum a range without including hidden cells? | Excel Worksheet Functions | |||
| How do I do a sumif function not including hidden rows? | Excel Worksheet Functions | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Linear Mode
