Jun 24 2022 12:08 AM
Hello,
Problem 01:
I used the sumif function in cell k30 & 31, it worked.
=SUMIF('Sheet 2'!G:G,C30,'Sheet 2'!I:X)
But not working in cell k44.
=SUMIF('Sheet 2'!G:G,C43,'Sheet 2'!I:X)
The value in k44 will be cell R37 of sheet2.
Problem 02:
In cell C46, I used the formula
="Retained Earnings: Tk. "&FIXED(K49,0)
The value comes in minus form: -46,541,677
I need it in paranthesis form: (46,541,677)
The excel file is attached herewith.
Thanks.
Jun 24 2022 12:37 AM - edited Jun 24 2022 12:38 AM
@Oliullah_Siddique The sum_range should not be multiple columns . When you do that it just takes the value from the first one. So, in fact all the numbers in Sheet1 come from column I, where I assume that the debits should come from column W:W and the credits from column X:X
Jun 24 2022 01:05 AM
Jun 24 2022 01:13 AM
@Oliullah_Siddique Try it this way:
="Retained Earnings: Tk. "&TEXT(-K49,"(#,##0)")