SUMIF
thanx a lot
"Mike H" wrote:
maybe this
=SUMPRODUCT((E3:E100DATE(2008,9,3))*(E3:E100<DATE (2008,9,16))*(G3:G100))
In practice I'd use cell rerences that point to the dates.
Mikr
"peyman" wrote:
hi guys,
I just wanna know if two conditions can be considered in the sumif
formula?like below:
= sumif(E3:E100, "3-sep-08 & <16-sep-08" , G3:G100)
Actually I tried it but the answer was wrong ,I need to know if there is any
modifications in the above formula?
I want to sum something in a time period like between Sep. 3 to 16.
Thanx,
Peiman
|