B
bruce
I have a Check Register Budgeting project. I want to total all of the checks
that cleared within a particular month for a particular accout. Each check
is recorded on a separate row so that Register!B4:B90 is the range that
contains the date the check cleared, Register!I4:I90 contains the
account/budget ID, and Register!D490 contains the amount the check was
written for that I want to total.
This is what I have tried so far to total only one date (01/15/2008):
=SUMPRODUCT(--(Register!B4:B9=DATE(2008,01,15)),--(Register!I4:I9=G5),Register!D49)
The formula above works, but when I try to replace the first array with a
date range like this it blow up:
=SUMPRODUCT(--(DATE(2007,12,31) < Register!B4:B90 <
DATE(2008,02,01)),--(Register!I4:I90="ACCOUNT#1"),Register!D490)
Any suggestions?
that cleared within a particular month for a particular accout. Each check
is recorded on a separate row so that Register!B4:B90 is the range that
contains the date the check cleared, Register!I4:I90 contains the
account/budget ID, and Register!D490 contains the amount the check was
written for that I want to total.
This is what I have tried so far to total only one date (01/15/2008):
=SUMPRODUCT(--(Register!B4:B9=DATE(2008,01,15)),--(Register!I4:I9=G5),Register!D49)
The formula above works, but when I try to replace the first array with a
date range like this it blow up:
=SUMPRODUCT(--(DATE(2007,12,31) < Register!B4:B90 <
DATE(2008,02,01)),--(Register!I4:I90="ACCOUNT#1"),Register!D490)
Any suggestions?