Hi,
Thanks for getting back to me but it's sorted now.
Can't believe how simply it was solved, I've used Domenic's answer although
how I never tried such a basic formula I'll never know.
Too many hours at it had obviously dulled the brain!
Thanks again

"Pecoflyer" wrote:


Hi, there must be another problem somewhere, the SUM function is not
affected by blank cells or text.
By registering ( free) on our forum , you could post a sample of your
data.
It would be easier to find what's wrong


Struggling in Sheffield;290614 Wrote:
Hi,
I'm trying to sum the total of the same cell in six adjacent
spreadsheets
(named 'July' to 'December') onto a separate summary sheet at the end.
My
problem is that many of the summed cells are blank which means my
formula
gives me a #VALUE! error. Current formula is:

=SUMIF(July:December!A108,"<""")

After trawling the forum for the answers to similar problems I came up
with
the formula above (also tried several variations) but it still returns
the
#VALUE! error when one or more of the summed cells is blank.

In addition, if all of the summed cells are blank, it would be nice to
get a
blank cell or £0.00 returned in the summary cell.

Thanks for looking and please help if you can.
Cheers,
Steve.


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81223