Excel Help

[Depression]

Ayi sumifs dala formula eka lyanakota operations walata ">" walata "" danne ?
ayi oya wage & danne ?

 

[wqe123]

ube prashne therenne naa
sumif Liyanakoya "<" ewa dannaa one na. ewa nathiwath liyanna puluwan

 

[Depression]

ube prashne therenne naa
sumif Liyanakoya "<" ewa dannaa one na. ewa nathiwath liyanna puluwan

hitpn photo ekak dannam

 

[wqe123]

ok

 

[Depression]

http://oi68.tinypic.com/dvj5es.jpg
mcn oke aran thyenne 2005 ta kalin karapu sales wala total eka
0 wadiyen kyla dala thyenne return karapu ewa adu karanne nathuwa total sales karapu gana balanna
net sales wala a return krpu gana adu krla dala tyenwa

ayi "" dala thyenne operations walata
ayi & dala thyenne

 

[ArunaTelshan]

ayi "" dala thyenne operations walata
ayi & dala thyenne

evaluate formula kiyana eka karala balanna. eken step by step pennanawa wena de...

 

[Depression]

evaluate formula kiyana eka karala balanna. eken step by step pennanawa wena de...

ayi bn " " and & dala thyenne

 

[ArunaTelshan]

& dala thiyenne concatenate karanna. quotes dala thiyenne oke criteria eka athule condition ekak thiyena hinda.

 

[Depression]

& dala thiyenne concatenate karanna. quotes dala thiyenne oke criteria eka athule condition ekak thiyena hinda.

mcn sumif eke ehema condition ekak thwunata " " danne na neda ?
& danne nathuwa kelimm "<1/1/2005" kyla dammata kamak nadda

 

[ArunaTelshan]

baha mcn sumif wala conditions danakota quotes athule danna one. "<", ">" wage

 

[Depression]

baha mcn sumif wala conditions danakota quotes athule danna one. "<", ">" wage

thanks mcn
ethakota ona formula ekaka condition ekak danawa nm " " athule danna ona neda ?

 

[ArunaTelshan]

thanks mcn
ethakota ona formula ekaka condition ekak danawa nm " " athule danna ona neda ?

ou "<"&"value" widiyata thama ennone

 

[Depression]

ou "<"&"value" widiyata thama ennone

ado thanks mcn
mata kypnko formula eka lyankota select karala thyena column eke udatama yanna shortcut key ekak, habayi ethakota udama cell eke reference eka formula ekata watenne nathi wennath ona

range eka select krgena pahalata awilla aye formula eka lyana cell ekata yanna ctrl+backspace ghla yanne

a wage shortcut ekak ona mcn

 

[ArunaTelshan]

ado thanks mcn
mata kypnko formula eka lyankota select karala thyena column eke udatama yanna shortcut key ekak, habayi ethakota udama cell eke reference eka formula ekata watenne nathi wennath ona

range eka select krgena pahalata awilla aye formula eka lyana cell ekata yanna ctrl+backspace ghla yanne

a wage shortcut ekak ona mcn

Shift + Arrows or Shift + Page up/down walin wade wenawada balanna.

ub qwa eka pahadili na mta.

 

[Depression]

Shift + Arrows or Shift + Page up/down walin wade wenawada balanna.

ub qwa eka pahadili na mta.

mehemayi
A10 eke formula ekak lynawa =B10+B11 kyla
dan select wela thyenne B11 cell eka
dan a column eke B1 cell ekata yanna shortcut ekak thyenda ( column eke udama cell ekata yanna )
ethakota habayi A10 eke thyena formula ekata B1 kyla reference eka add nowenna yanna ona

shift page up ebuwama B11:B1 wenakan reference eka add wenwa

 

[ArunaTelshan]

Ctrl + Up arrow ?

 

[Depression]

Ctrl + Up arrow ?

ethakotath cell reference eka watenwa bn formula ekata

 

[ArunaTelshan]

ethakotath cell reference eka watenwa bn formula ekata

ehemanam mouse eke wheel eka obagena udata aran yana eka lesi..

 

[Depression]

ehemanam mouse eke wheel eka obagena udata aran yana eka lesi..

ehema thama krnne danata
mn hithuwe mkak hari lesi widyak athi kyla anyway thanks for your great help