That'll work, shouldve thought of it, thanks!

"Sheeloo" wrote:

Use
=IF(April!I1="","",April!I1)


"JAbels001" wrote:

Unfortunately that is a harder task than getting the subtotal to exclude
them. Is there anyway to have a cell that only shows the value of another
cell just what is in that cell? For example on my one tab I have a formula
that reads "=April!I1", however if I1 on tab "April" is blank then it shows
"0" not blank. I would like it to show the true contents.

"Gord Dibben" wrote:

Get rid of the errors in the cells being subtotalled.

Trap for it in your formulas.

Post an example of two of the cells that return #VALUE! that are causing
the error in the Subtotal.


Gord Dibben MS Excel MVP

On Fri, 30 Jan 2009 12:09:01 -0800, JAbels001
wrote: