SUMIF/SUMPRODUCT??

  • Thread starter Thread starter Ket
  • Start date Start date
K

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
 
Ket said:
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
Click to expand...

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.
 
Hi Ket,

Try this formula:

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