SUMIF
 

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

SUMIF
 

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

"peyman" wrote in message
...
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

SUMIF
 

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

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

SUMIF
 

Thanx David

"David Biddulph" wrote:

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

"peyman" wrote in message
...
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