SUMIFS function in Excel 2007

Hi,

I’m trying to use the SUMIFS function in Excel 2007 to evaluate the following formula:

{=SUMIFS(range to sum, range to evaluate, evaluation criterion)}

The range to sum is A1:A10, the range (dates) to evaluate are in B1:B10, and the evaluation criterion is that the date is before 31/10/1999.

So my formula looks like this:

{=SUMIFS(A1:A10,B1:B10,”<31/10/1999”)}

This works fine, but how do I refer the 3rd argument in the function to a date in a particular cell rather than typing in the date specifically?

Thanks!

You only need to use SUMIFS if you have more than 1 criteria, if you have one criteria you should use SUMIF ... also neither SUMIF nor SUMIFS are Array formulae so no need for CSE - ie { }

=SUMIF(B1:B10,"<"&C1,A1:A10)

where C1 holds date of interest