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
|