SUMPRODUCT: can sum a cell formula result?

[matrix_qw]

I'm totally lack of experience, this is easy for you guys, if someone can help me i need to deliever this report to my boss.

Cell I27=SUMPRODUCT((MOD(ROW(I10:I25);3)=1)*(I10:I25))

Cells I10 contains a formula =SUM(D10:H10) and so on...

so the result of cell I27 is #VALUE! because it reads the formula (=SUM(D10:H10) instead of the result of that formula

What do i need to do?!

[daddylonglegs]

I would suggest that there is another cause of that error. It doesn't matter to SUMPRODUCT whether the cells have just numbers or formulas, as long as those formulas don't return errors.

Your SUMPRODUCT is summing every 3rd cell, i.e. I10, I13, I16 etc. but using that syntax any text in the intermediate cells, i.e. I11, I12 etc. will trigger an error. If there is text in those cells try changing to

=SUMPRODUCT(--(MOD(ROW(I10:I25);3)=1);I10:I25)

or, slightly more robust

=SUMPRODUCT(--(MOD(ROW(I10:I25)-ROW(I10);3)=0);I10:I25)

[matrix_qw]

You are right, i didn't though it was due to text because if i replaced the formula with a number it would result ok.
Well, thanks alot, i need to work alot on excel