If by 'value' you mean a number, then

=SUMPRODUCT(--ISNUMBER(Q1:Q7),B1:B7)

If you mean a non-blank cell, then

=SUMPRODUCT(--NOT(ISBLANK(Q1:Q7)),B1:B7)


"Lisa" wrote:

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???