formula with 2 criteria, Excel 2002

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
try either
=SUMIF(H4:H21,">=8",D4:D21)-SUMIF(H4:H21,">=15",D4:D21)

or try
=SUMPRODUCT(--(H4:H21>=8),--(H4:H21<=14),D4:D21)
 
I have 2 columns, H and D. The range is 4:21
H is a general format (no decimals) representing the day of the month
(1-31)
D is formatted currency $.

I want the total of D in currency format but just between 2 dates.

I'd want to repeat the formula another 3 times, representing a 4 week
period, ie:
=8, <=14
=15, <=21
=22, <=28
=29, <=31
Click to expand...

Thanks.
 
It looks like the formula is correct. It equalled $0 because there were
no values between 8th and 14th try the formula for the next week. It
will work.

Rgds,
Prashanth
 
Thanks Frank, I think I'm a bit closer than I was. Here's some more
info....

Here are the figures :
Col D $ Col H date

5
12
13
19
26
27
755.66 1
131.66 1
50 1
271.30 1
813.90 5
32.14 15
200.00 15
58.60 15
201.26 17
99.13 15
215.00 25
178.92 30
----------------------
755.66
131.66
50
271.30
813.90
= $2022.52

Thanks again.
 
Back
Top