#Value! error in cell
Hi,
try
=SUMIF(H12:I12,"<#Value!")
"shallowz" wrote:
I am getting #Value! in a cell that has a formula of course
I pretty sure I know the problem but I dont know how to fix it
:)
in the Cell with the "#Value!" error is a simple formula =SUM(H12:I12)
In Cell H12 is a formula that is dependent on another cell for information
so its empty except for the formula
When information is placed in the cell H12 the "#Value!" error goes away and
it does its job
How do I hide that "#Value!" until the time when information is placed in H12
I hope I explained the situation correctly
|