Sum amount with dates

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

Hi,
Could I get some help to add a date between condition for
my formula!
Column D has the dates and if the certain conditions
exists in and [F]I'd like to total from [J].

So far with my variations on this theme I've been getting
0 as a result.

=SUM(IF((B3:B1000=38)*(F3:F1000="CTU")*
(D3:D1000>2/1/2004<23/1/2004),J3:J1000))array entered.

TIA
 
Gerry,

=SUM(IF((B3:B1000=38)*(F3:F1000="CTU")*(D3:D1000>DATE(2004,2,1))*(D3:D1000<D
ATE(2004,1,23)),J3:J1000))

array entered or

=SUMPRODUCT((B3:B1000=38)*(F3:F1000="CTU")*(D3:D1000>DATE(2004,2,1))*(D3:D10
00<DATE(2004,1,23)),J3:J1000)

non-array entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks very much!
-----Original Message-----
Gerry,

=SUM(IF((B3:B1000=38)*(F3:F1000="CTU")*(D3:D1000>DATE (2004,2,1))*(D3:D1000<D
ATE(2004,1,23)),J3:J1000))

array entered or

=SUMPRODUCT((B3:B1000=38)*(F3:F1000="CTU")*(D3:D1000>DATE (2004,2,1))*(D3:D10
00<DATE(2004,1,23)),J3:J1000)

non-array entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi,
Could I get some help to add a date between condition for
my formula!
Column D has the dates and if the certain conditions
exists in and [F]I'd like to total from [J].

So far with my variations on this theme I've been getting
0 as a result.

=SUM(IF((B3:B1000=38)*(F3:F1000="CTU")*
(D3:D1000>2/1/2004<23/1/2004),J3:J1000))array entered.

TIA
Click to expand...



.
Click to expand...
 
Back
Top