Forum Discussion
Solved
Need to Sum from cell which the value comes from formula
Hi Guys!
I need help to sum my table. In case, I need to sum range which contains formulas (If) such as:
in Cell A1 100; A2 200
Then in B1 I put formula,=IF(A1=100;"1";"2")
B2 =IF(A1=100;"1";...
Hi Sandi,
In your yellow zone which you try to sum you have text only which is generated by formulas like
=IF(RIGHT([@Tarif],1)="T","1","")
SUM() ignores any text and returns zero since you have no one number in the range. You may update your formulas to return numbers instead of text, like
=IF(RIGHT([@Tarif],1)="T",1,"")
or to sum all cells which have text string "1" use
=SUMPRODUCT(--([MPB]="1"))
Please see attached
Hi Sergei,
Thank you for your response, I just came back to office. In case, in cell A1 is validated number, so if it doesn't mind you, would you like to open my file and see the cells which I need to sum.
Thank you so much, very need help :)
Thank you for your response, I just came back to office. In case, in cell A1 is validated number, so if it doesn't mind you, would you like to open my file and see the cells which I need to sum.
Thank you so much, very need help :)
Hi Sandi,
In your yellow zone which you try to sum you have text only which is generated by formulas like
=IF(RIGHT([@Tarif],1)="T","1","")
SUM() ignores any text and returns zero since you have no one number in the range. You may update your formulas to return numbers instead of text, like
=IF(RIGHT([@Tarif],1)="T",1,"")
or to sum all cells which have text string "1" use
=SUMPRODUCT(--([MPB]="1"))
Please see attached
Great! everything I need is working :)
Thank you so much :)