#VALUE! error while using sum two cells having VLOOKUP

[mwvirk]

how i can resolve this #value! error since i have 2 different formulas in cell BR & BS:

MWVirk PSX Portfolio v0004.xlsx
	BR	BS	BT
32	13,914.94	11,900.00	25,814.94
33	4,964.18	2,992.00	7,956.18
34			#VALUE!
35			#VALUE!
36			#VALUE!
37			#VALUE!
38			#VALUE!
39			#VALUE!
40			#VALUE!
41			#VALUE!
42			#VALUE!
43			#VALUE!
44			#VALUE!
45			#VALUE!
46			#VALUE!
47	-578,863.36	0.00	-578,863.36
48	3,110.30	0.00	3,110.30
PSX Profit & Loss

Cell Formulas
Range	Formula
BR32:BR48	BR32	=IF(ISNA(VLOOKUP(A32,'PSX Portfolio Status'!A:BN,31,FALSE)),"",VLOOKUP(A32,'PSX Portfolio Status'!A:BN,31,FALSE))
BS32:BS48	BS32	=IF(ISNA(VLOOKUP(A32,'PSX Portfolio Status'!A:BN,54,FALSE)),"",VLOOKUP(A32,'PSX Portfolio Status'!A:BN,54,FALSE))
BT32:BT48	BT32	=BR32+BS32

Named Ranges
Name	Refers To	Cells
'PSX Portfolio Status'!_FilterDatabase	='PSX Portfolio Status'!$A$1:$BN$1	BR32:BS48

 

[Peter_SSs]

but i don't want to hide the 0 value for the entire sheet

There were many options in the link that Joe gave you, that was just one of them.
One of the other options was ..

.. which applied to your situation would be, using Alex's original suggestion, ..

=IF(SUM(BR32:BS32)=0,"",SUM(BR32:BS32))

 

[Alex Blakenburg]

is it possible to avoid 0.00

I think this statement needs to be read in conjunction with the image posted. In theory the first amount column was Profit/Loss so could be negative and unlikely as it might be the Sum of the 2 amounts could come to zero and should show as such.
The image was more indicative that the sum function column was pre-populated but the data was not and the OP didn't want 0 to show on the unpopulated rows.