Adding every third cell in a column
 

I need a formula for a cell that will add the value in every cell in a
specified column that has the name "Plan" in the cell in the previous column.

On Thu, 21 Apr 2005 14:23:02 -0700, "Jack Thiel"
wrote:

I need a formula for a cell that will add the value in every cell in a
specified column that has the name "Plan" in the cell in the previous column.

Check HELP for SUMIF.

If "Plan" may or may not be in Column A; and your values to be added are in
Column C, then

=SUMIF(A1:A1000,"Plan",C1:C1000) might work.

If Column A contains Plan plus other stuff, then use wild card:

"*Plan*"

for example.


--ron

That worked, Ron. Thanks much.

"Ron Rosenfeld" wrote:

On Thu, 21 Apr 2005 14:23:02 -0700, "Jack Thiel"
wrote:

I need a formula for a cell that will add the value in every cell in a
specified column that has the name "Plan" in the cell in the previous column.

Check HELP for SUMIF.

If "Plan" may or may not be in Column A; and your values to be added are in
Column C, then

=SUMIF(A1:A1000,"Plan",C1:C1000) might work.

If Column A contains Plan plus other stuff, then use wild card:

"*Plan*"

for example.


--ron

On Thu, 21 Apr 2005 14:59:06 -0700, "Jack Thiel"
wrote:

That worked, Ron. Thanks much.


You're welcome. Thank you for the feedback.


--ron