Need to add every third value in a row of data

  • Thread starter Thread starter baurian
  • Start date Start date
B

baurian

Hi,

I need to add every third value in a row of data and I do not know how.

Thank you,

Benedict
 
Try this:

=SUMPRODUCT(--(MOD(ROW(A1:A100),3)=0),A1:A100)

Assumes you are trying to add from column A - adjust to suit. It will
add rows 3, 6, 9, 12 etc.

Hope this helps.

Pete
 
Just noticed you said the data is in a row. Change the formula to
this:

=SUMPRODUCT(--(MOD(COLUMN(A2:AA2),3)=0),A2:AA2)

This looks at row 2 and adds every third column from C onwards.

Hope this helps.

Pete
 
Thank you, Pete. It works with numbers; it does not seem to work with (date
time) in the cell.

Benedict
 
If they are Excel data/times they are numbers, maybe you only need to format
it the right way like [h]:mm etc or
maybe they are text but look like numerical dates times?

--


Regards,


Peo Sjoblom
 

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

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
IF need to add a third value 6
Excel Help to copy information from one row at a time to another sheet 1
how do I select every third cell in a row in excel? 8
How do I add rows at fixed intervals-add values after every 5 Rows 3
How to filter rows data based on background color of individual cells 1
How to shade every third row? 10
How do I insert a row after every row of data in XL? 5

Back
Top