SUMIF/SUMPRODUCT??

[Ket]

Hello,

Column A contains reference letters, Column B contains dates, Column C
contains values.

What formula must I use the looks at column A and if the reference
equals, say, RR and the date is greater than 01/01/05 and less than
10/01/05, the corresponding values in column C are added together?

Thanks in advance for all assistance offered.

Regards

Ket
London

 

[Peter Aitken]

Hello,

Column A contains reference letters, Column B contains dates, Column C
contains values.

What formula must I use the looks at column A and if the reference
equals, say, RR and the date is greater than 01/01/05 and less than
10/01/05, the corresponding values in column C are added together?

Thanks in advance for all assistance offered.

Regards

Ket
London

I don't think that's possible with SUMIF. This function looks at only one
column for the criterion. You need to look at two, one for reference and one
for date.

Look at DSUM. You'll have to set up your criteria in a separate worksheet
region and then refer to this range in the formula.

 

[Guest]

Hi Ket,

Try this formula:

=SUMPRODUCT(--(A1:A10="RR"),--(B1:B10>DATEVALUE("1/1/2005")),--(B1:B10<DATEVALUE("10/1/2005")),C1:C10)