sumif formula!

[jimmisavage]

I need to add some number together in d4:d14, but only add the numbers if a4:a14 say 730.

so...

a d

730 1
730 1
830 0
600 0
900 1

So i need the answer to be 2.

[dominicb]

Good afternoon jimmisavage

I need to add some number together in d4:d14, but only add the numbers if a4:a14 say 730.

How about :
=SUMIF(A1:A14,730,B1:B14)

HTH

DominicB

[arthurbr]

The SUMIF formula seems to be what you need.
Did you give it a try? Did something go wrong?

[jimmisavage]

Thank you. It worked, but its just the beginning! I'll come back if i need any more help.

Thanks again