| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you ignore hidden rows in a SUMIF() function?
I would like to use the SUMIF function to sum all negative cash flows
(=SUMIF('Worksheet A - Info & Gross IRR'!EH5:EH2001,"<0")) in a given column of data with hidden values (the data is in rows that have been hidden using Autofilter and certian criteria). I would like the SUMIF function to ignore the the hidden values (transactions we don't want included in our analysis). Any advice is apprectiated. Thanks, Gerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you ignore hidden rows in a countif() function | Excel Worksheet Functions | |||
| Radom hidden rows | Excel Discussion (Misc queries) | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) | |||
Threaded Mode
