Did you add the sheet name for each of the references?

In article ,
"Gerry" wrote:

Unfortunately, when testing it, the result came back as 0 when it should have
returned a -2.4. Could it be that I keyed something in wrong like the "--"
or should we have quotes around <0 as in "<0"? Any trouble shooting ideas?
Thanks.

"Domenic" wrote:

Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(EH5:EH2001,ROW(EH5:E H2001)-ROW(EH5),0,1)),-
-(EH5:EH2001<0),EH5:EH2001)

Hope this helps!

In article ,
"Gerry" wrote:

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