!!!!!!!! Excel Help !!!!!!!!!!!

[Chrisad]

loipon se ena fyllo ayto ton typo

 

>
=SUMIF('Φύλλο1'!$A:$A;"<01-06-2002";'Φύλλο1'!$D:$D)

 

se mia arketa megalh katastash....

 

ayto pou thelw einai to kommati ayto ths hmeromhnias

>
"<01-06-2002"

na mhn einai stathero alla na einai h anafora enos kelioy p.x

 

>"<F1"

etsi oste an alaksw thn hmeromhnia sto keli

>"<F1"

na allazei kai aytomata to apotelesma sta kelia pou ti exoun ton typo....

 

an omws syntaksw ton typo etsi :

 

>
=SUMIF('Φύλλο1'!$A:$A;"<F1";'Φύλλο1'!$D:$D)

 

to excel agnoei thn hmeromhnia pou bazw sto keli "F1"

 

mporei kaneis na bohthisei'?

[random]

loipon se ena fyllo ayto ton typo

 

>
=SUMIF('Φύλλο1'!$A:$A;"<01-06-2002";'Φύλλο1'!$D:$D)

 

 

try this

>
=SUMIF('Φύλλο1'!$A:$A;  "<"&F1      ;'Φύλλο1'!$D:$D)

 

http://www.excelforum.com/t169083-s