I need to know how to write a conditional sum (or DSUM or other) formula
involving multiple worksheets(wks1-5) in a workbook.
Here is my failed attempt in wks1:
=SUM(IF(wks2DateColumn=B38 and <=C38,"",wks2AmtColumn))
wks1 contains a StartDate column and an EndDate column; the two dates in one
row defines a Quarter calendar(spanning down 20 years). The next cell in
each row will contain the SUM(IF..) formula, which is to calculate numerous
records in worksheets 2 to 5 (each with data in identical columns). Next,
copy the formula down for all 80 Quarters with cells B38 and C38 being
relational, completing analysis of wks2. Then copy the formula in other wks1
columns for the other three worksheets. How to write it step-by-step? Can
the formula be "relational"?

=SUMPRODUCT(--(wks2DateColumn=B38),--(wks2DateColumn<=C38),wks2AmtColumn)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Frenchy" wrote in message
...
I need to know how to write a conditional sum (or DSUM or other) formula
involving multiple worksheets(wks1-5) in a workbook.
Here is my failed attempt in wks1:
=SUM(IF(wks2DateColumn=B38 and <=C38,"",wks2AmtColumn))
wks1 contains a StartDate column and an EndDate column; the two dates in
one
row defines a Quarter calendar(spanning down 20 years). The next cell in
each row will contain the SUM(IF..) formula, which is to calculate
numerous
records in worksheets 2 to 5 (each with data in identical columns). Next,
copy the formula down for all 80 Quarters with cells B38 and C38 being
relational, completing analysis of wks2. Then copy the formula in other
wks1
columns for the other three worksheets. How to write it step-by-step?
Can
the formula be "relational"?

Perhaps:
=SUMPRODUCT(--(wks2DateColumn=B38), --(wks2DateColumn<=C38), wks2AmtColumn)


"Frenchy" wrote:

I need to know how to write a conditional sum (or DSUM or other) formula
involving multiple worksheets(wks1-5) in a workbook.
Here is my failed attempt in wks1:
=SUM(IF(wks2DateColumn=B38 and <=C38,"",wks2AmtColumn))
wks1 contains a StartDate column and an EndDate column; the two dates in one
row defines a Quarter calendar(spanning down 20 years). The next cell in
each row will contain the SUM(IF..) formula, which is to calculate numerous
records in worksheets 2 to 5 (each with data in identical columns). Next,
copy the formula down for all 80 Quarters with cells B38 and C38 being
relational, completing analysis of wks2. Then copy the formula in other wks1
columns for the other three worksheets. How to write it step-by-step? Can
the formula be "relational"?