• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Subtotal(offset) function results error

Farhad Sam

New Member
I have got the formula combination in this group, and it really a good one. but I am suffering a bit to understand why its acting weird when I starting the column function in a distance and giving the wrong subtotal value?

Please take a look in the image. Thanks in advance.
 

Attachments

  • Subtotal(OFFSET).PNG
    Subtotal(OFFSET).PNG
    30.9 KB · Views: 9
76978

Change your L6 formula, Column function :

From >>

COLUMN($D$5:$J$5)

Into >>

COLUMN($D$5:$J$5)-COLUMN($D$5)+1

So,

it will always start from 1, and become --> {1,2,3,4,5,6,7}

Regards
 
Last edited:
Back
Top