Hi Lisa,

=SUMIF(A1:A5,"a",B1:B5)
=SUMIF(A1:A5,C1,B1:B5)

Sums the value in Col. B if Col. A has an "a", no quotes, or you can refer
to a cell like in the second formula.

HTH
Regards,
Howard

"Lisa" wrote in message
...
I would like to create a formula that would add up a range of cells in
column
B only if there is a value entered in Column Q. I've tried a couple of
things to no avail. Any suggestions???