A arifanmol Member Jan 25, 2023 #1 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 Myself.xlsx Myself.xlsx 8.7 KB · Views: 3
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
A arifanmol Member Jan 26, 2023 #3 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.
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.
A arifanmol Member Jan 26, 2023 #4 by the way plz check what s wrong in the formula in attached file Attachments Hello Excel.xlsx Hello Excel.xlsx 7.6 KB · Views: 1