SUMIF

[peyman]

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

 

[Mike H]

maybe this

=SUMPRODUCT((E3:E100>DATE(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]

thanx a lot

maybe this

=SUMPRODUCT((E3:E100>DATE(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]

Thanx David

=SUMPRODUCT(--(E3:E100>DATE(2008,9,3)),--(E3:E100<DATE(2008,9,16)),G3:G100)