Excel tips and tricks

scaeagles · 09-22-2005, 09:58 AM

My solution, if possible.

I would add another column C. Column C has the following formula in each cell in the column -

=if (a1="yes",b1,"")

When copying the formula, of course the cell references change.

At the bottom of column C, a simple sum can be used for the range of data. This way, whenever the value of column A changes to or from yes, the data in column C is updated appropriately, and thus the total.

Of course, that only works if you can add column C.

09-22-2005, 09:58 AM	#1
scaeagles I LIKE! Join Date: Jan 2005 Posts: 7,819	My solution, if possible. I would add another column C. Column C has the following formula in each cell in the column - =if (a1="yes",b1,"") When copying the formula, of course the cell references change. At the bottom of column C, a simple sum can be used for the range of data. This way, whenever the value of column A changes to or from yes, the data in column C is updated appropriately, and thus the total. Of course, that only works if you can add column C.
	Submit to Quotes