Excel Help.... Plz.........

[rambabu304]

excel guru's plz help me......

Column A lo ee status vundadu

In Process
Hold
Complete
Cancelled

Column B lo Dollar value vundi.....

Now I need a sum for the Column B which will only take the values of corresponding cell from Column A which have the status as "In Process" & "Hold..... "

clear ga chepalli antey -

column A column B
In Process $100
In Process $100
Hold $100
In Process $100
Complete $200
Complete $200
Cancelled $50

sum = $400

[rambabu304]

zaara kocham help cheyaandi bhayaa........

[maximummax]

Check this out
http://office.microsoft.com/en-us/excel-help/sum-values-based-on-multiple-conditions-HA102809345.aspx

[@Shadow@]

columns ni rows ga maarchey ......... easy ga work aipothadhi [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[rambabu304]

[quote name='@Shadow@' timestamp='1366120209' post='1303611354']
columns ni rows ga maarchey ......... easy ga work aipothadhi [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]

[rambabu304]

[quote name='Burberry' timestamp='1366119951' post='1303611323']
Check this out
[url="http://office.microsoft.com/en-us/excel-help/sum-values-based-on-multiple-conditions-HA102809345.aspx"]http://office.micros...A102809345.aspx[/url]
[/quote]

Thanks dude.......... edi use cheyaledu kani... deeni base chesukoni sumif + sumif formula use chesaa... vachinidi.. thanks.........

[maximummax]

solution doriknida

[rambabu304]

[quote name='Burberry' timestamp='1366124429' post='1303611738']
solution doriknida
[/quote]

dorikindi bhaya..... thanks..........