Adding every third cell in a column

J

Jack Thiel

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
J

Jack Thiel

That worked, Ron. Thanks much.

Ron Rosenfeld said:
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
Click to expand...
 
Top