summing up

[torpido]

hi m8's

i have a column which holds numbers and i have a another column which holds words,
for E.g:
A======================B
1 Top Up-----------------[1] 1000
2 New--------------------[2] 100
3 Top up-----------------[3] 10

\1

i want rows which are Top Up (B1 & B2) to be auto Calculated, how?

thanks and regards

[davesexcel]

Check out sumif
enter =sumif(
then click the fx by the formula bar and follow the directions

[torpido]

example please, if you want a sample plz let me know

[davesexcel]

example please, if you want a sample plz let me know

Hi torpido,
Which part of click the fx didn't work for you?
It's called the function wizard and it will help you build your formulas,
enter
=sumif(
in the cell you want the result.
then click the function wizard to build your formula..........


Would it not have been just as easy to supply a sample workbook instead of attaching a picture?

[torpido]

NP m8, here is a sample
btw i tried Fx but couldn't figure out, sorry!

[davesexcel]

Try this
=SUMIF(A2:A13,A17,B2:B13)

[torpido]

hehe, how didnt i have thought of that, so simple.
thanks alot m8.