Nested SumIF?

[SPJ]

Hi I need to sum only the negative numbers from 2008 and my sheet looks a
little like this;

1/1/2007 3/2/2008 5/1/2008 6/2/2008
-12,000 24,000 -75,000 -15,000

What forumula do I use to get this result?

Thanks in advance to anyone who can help.

 

[Skinman]

Try

=SUMIF(A12,"<0")
This assumes your data starts at cell A1 and ends in D2. A better way would
be to name the range
Select all the cells and name them something like Datum. Once done your
would change your formula to:-
=SUMIF(Datum,"<0")
Skinman.

 

[SPJ]

Thanks but I need to sum only the negative numbers AND only the numbers from
2008. Any ideas?

Thanks

 

[CyberTaz]

One option - this example assumes the dates are in A8:F8 and the values to
be conditionally summed are in A9:F9

=SUMIFS(A9:F9,A8:F8,">12/31/2007",A9:F9,"<0")

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

One option - this example assumes the dates are in A8:F8 and the values to
be conditionally summed are in A9:F9

=SUMIFS(A9:F9,A8:F8,">12/31/2007",A9:F9,"<0")

Or, if your workbook needs to work in versions before XL07/08:

=SUMPRODUCT(--(YEAR(A8:F8)=2008),--(A9:F9<0),A9:F9)