• 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.

Auto sum formula

arifanmol

Member
can we have the formula that argues : if the text 'total' in in this particular cell then
put sum of cell right above 'total' cell and B3
see the attached file plz
 

Attachments

arifanmol

Member
SUM function is right but i want if condition with sum
i want that upper cell (i.e. from B10 to B8) should be activated and text from that cell should be selected.
 
Top