Hi,

what is the formula in your total column?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JenOrr" wrote:

That worked but if they answer no, it puts #VALUE! in my total column

"JE McGimpsey" wrote:

One way:

In F25:

=IF(J10="Yes", B25, "")

In article ,
JenOrr wrote:

I am trying to set up a sales order, I need to set up a formula that if they
answer yes, then the qty from one column will be transferred to another
column.

Example if they answer yes to glazing in J10, then F25 will equal B25.