Hello. I read or at least went through all the user manual. And I think I did not find it in there. For huuuuge simplification of my work, I would really appreciate a function which would sum cells in regular order. For instance each 11th cell of Q-column: Q11, Q22, Q33, Q44 etc. Or the same in a row. Or the same but not sum but COUNT, AVERAGE or general IF(S) functions.
For instance, the “each 11th” would be an array function like
=SUMIFS(A1:A35;MOD(ROW(A1:A35);11);0)
You are wrong. You did not get what I mean. SUMIFS is function which sums cells by the selected values (criteria aka IFS aka conditions) of cells not by the order of cells.
Are you sure? The example is about the order. You define the formula that gives the order as the criteria to the function.
Sorry. I did not descroll whole your comment. I read only the first line.
I tried to use your formula. In a sheet, I made column from A1 to A35 with numbers from 1 to 35. And it says “error 504”. There must be some error in it.
I have no knowledge of any array. I thought your formula is easily replicable.
Entering an array function: you type the formula, and instead of Enter to finish it, you press Ctrl+Shift+Enter.
A simple formula may be
=SUMPRODUCT(A1:A35;MOD(ROW(A1:A35);11)=0)
using the extremely powerful SUMPRODUCT.
2 Likes
It works! Sorry. I read the manual in my language and my brain did not have the connection array=matice. Now it works. Thank you very much! You saved me a lot of time!