Hi,

I got formulas' 1 & 2 from this NG and tried to make come up with the
formula I needed from samples posted in this NG but I was not able to.

Please help.

Columns: G=Amount, I=Date Posted and J=Date Sent
1. =SUMIF($I$2:$I1116,"=6/30/07",$G$2:$G1116) = Sum up items in Col: G
based on Col: I dated 6/30/07
2. =COUNTIF($I$2:$I1116,"=6/30/2007") = Count items in Col: G based on Col:
I dated 6/30/07

Need formulas to include Col: J as additional creiteria:
a. Change "=6/30/07" to inclusive dates, i.e., 1/1/07 to 6/30/07
b. Sum up items in Col: G based on Col: I dated 1/1/07 to 6/30/07 and Col: J
(dated)
c. Sum up items in Col: G based on Col: I dated 1/1/07 to 6/30/07 and Col: J
NOT sent (cell is blank)
d. Formulas to COUNT a, b, and c