Thank you everyone! The =sumif that you all suggested worked perfectly! You
are all very helpful and thank you for the quick response!
Kristen



Bill Kuunders wrote:
=sumproduct(--(F1:F1000="B"),(E1:E1000))
sumproduct needs a defined column length. I selected 1000

or you could try =sumif(F1:F1000,"B",E1:E1000)

with a sumproduct formula you can have more than one condition

see.....http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Hi All!

[quoted text clipped - 11 lines]
Thank you!
Kristen

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200802/1