Hello
I have data in row 1 and go from column A to P. Is there a formula that help me SUM numbers following order 4, 4, 5. For example, I want to sum A1:D1, then SUM E1:H1, then SUM I1:M1, continue to do with longer data with a pace of 4, 4, 5.
Hello
I have data in row 1 and go from column A to P. Is there a formula that help me SUM numbers following order 4, 4, 5. For example, I want to sum A1:D1, then SUM E1:H1, then SUM I1:M1, continue to do with longer data with a pace of 4, 4, 5.
tantcu,
Why can't you just use
=SUM(A1:D1)
=SUM(E1:H1)
=SUM(I1:M1)
=SUM(N1:Q1)
=SUM(R1:U1)
=SUM(V1:Z1)
etc.
Am I missing something?
Imagine if I have like more than 1000 data. It would be convienence for me to have a set of formula to drag out.
If possible attach the sample file
Please consider adding a * if I helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks