Jan 22 2021 09:37 AM
Jan 22 2021 12:13 PM
Jan 22 2021 01:13 PM
Jan 23 2021 06:18 AM
Depends on which version of Excel you are. If on one which supports dynamic arrays that could be
=J:J+3 + IF(OR(A:A="customer1",A:A="customer2"),6,0)
If not, drag formula down. In both case it's better to use Excel Tables or at least dynamic ranges.