Adding every third cell in a column

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
how do I select every third cell in a row in excel? 8
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Update total based on two columns 1
Sum of every nth cell in a column 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top