what fomula would I use to add criteria in one cell only when the cell next
to it has data entered? Basically, I don't want the first cell to be part of
a formula until it has relevency. The cells are not part of a continuous
range either(i.e. they might be a4, a14,a24,a34 etc.)